Search results

Can you Modify this code? My range and my combo box is not in one page My range is in sheet2 and my combo box is in sheet 1. Private Sub TextBox1_Change() Dim rng As Range, cell As Range Me.ComboBox1.Clear If Len(Me.TextBox1.Value) Then...

I have posted a question and I don't know If I need to enter this question in the continuation of that thread or I should start a new thread. I did the VLookUp and I put the result in column F, I filtered on #N/A values and used another data set as a source. I got some values, now I want to...

I will post my file, I need to insert a combo box that shows the employee, Perhaps If I want to get suggestion on the names, I have to enter a text box, which when I enter characters into the text box, it gives me suggestion in Combo box. The solution on the top doesn't work for my purpose. I...

How does this work? Please GN0001

I wonder If I want to continue, are you there to help me? I need a couple of combo boxes and two or three text boxes and the result to be shown in a grid or whatever control is designed to show the result. GN0001

Your solution seems correct, but I don't want to move data from one sheet to a fresh sheet for a couple of reasons: 1-Data changes when we move it a lot, like the leading zeros are dropped in Excel. 2-It will be time consuming. Thank you anyway, GN0001

Great, It worked. Thank you very much. GN0001

First I can't follow what you say Second I need something easy and not time consuming.

This is doen't work for my purpose. I want to paste as this first row 4 second row blank third row 6 I need to blank rows stay in between. Regards, GN

The code should take care of this task that when an end user enters some characters in the combo box, it suggests us whole string. For example if enter b, combo box should suggests all the names starting with b. Any code? I appreciate your help. Thanks, GN

I have values in a column: Column A 4 row 1 5 row 2 6 row 3 7 row 4 I do a filter on this column and I select only 4 and 6 Then I go to select visible cells and select two non-adjacent cells make a copy and then go to a different column and select the first cell and then I pasted values...