[Solved] How do I use a combobox and textbox on a userform in VBA to search and find data on the active Excel spreadsheet?

So her is a new Solution. You have to declare 3 Public Variables in the UserForm1 Modul. So you can give them Values while the USerForm is open and Find the Naxt Values when you click multiple Times on the Search Button. ‘Public Variables Public bolFirstSearch As Boolean Public rng As Excel.Range Public cellFound As … Read more

[Solved] Show text box after choose in drop down list

protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e) { if (DropDownList1.SelectedItem.Text == “A”) { TextBox1.Visible = true; TextBox2.Visible = true; TextBox3.Visible = true; TextBox4.Visible = true; TextBox5.Visible = true; } else { // do something } } By default, make sure you set the Visible property of the Textbox controls to False. Enable the AutoPostBack of the … Read more

[Solved] How to merge two multiline textboxes

There are probably many ways you could do this. I have shown you one below but you would be assuming that textbox two contains the same amount of lines as textbox 1. It doesnt contain any validation but would do what you are asking. See the comments to understand what is happening. ‘Declare empty string … Read more