Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
VBA cell to textbox
I'm having an issue if anyone could help.
I'm very new to VB/VBA and I'm trying to Search a spreadsheet for specific text in column A, when it finds that data make the cell that data is in the Active cell , then move to column b the same row the data was on and select the text there, Then paste it to a textbox, then it would have to go to column d and do the same, How would i go about doing this? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
VBA cell to textbox
Make TextBox1, TextBox2 and TextBox3 on a Form
Doubleclick on TextBox1 Insert folowing code except first and last line : Start Form and put searc value in TextBox1 Private Sub TextBox1_Change() On Error Resume Next Me.TextBox2 = "": Me.TextBox3 = "" Me.TextBox2 = Range("A1:A10").Find(Me.TextBox1, LookIn:=xlValues).Offset(0, 1) Me.TextBox3 = Range("A1:A10").Find(Me.TextBox1, LookIn:=xlValues).Offset(0, 3) End Sub " skrev: I'm having an issue if anyone could help. I'm very new to VB/VBA and I'm trying to Search a spreadsheet for specific text in column A, when it finds that data make the cell that data is in the Active cell , then move to column b the same row the data was on and select the text there, Then paste it to a textbox, then it would have to go to column d and do the same, How would i go about doing this? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
VBA cell to textbox
On Oct 22, 12:55 pm, excelent
wrote: Make TextBox1, TextBox2 and TextBox3 on a Form Doubleclick on TextBox1 Insert folowing code except first and last line : Start Form and put searc value in TextBox1 Private Sub TextBox1_Change() On Error Resume Next Me.TextBox2 = "": Me.TextBox3 = "" Me.TextBox2 = Range("A1:A10").Find(Me.TextBox1, LookIn:=xlValues).Offset(0, 1) Me.TextBox3 = Range("A1:A10").Find(Me.TextBox1, LookIn:=xlValues).Offset(0, 3) End Sub " skrev: I'm having an issue if anyone could help. I'm very new to VB/VBA and I'm trying to Search a spreadsheet for specific text in column A, when it finds that data make the cell that data is in the Active cell , then move to column b the same row the data was on and select the text there, Then paste it to a textbox, then it would have to go to column d and do the same, How would i go about doing this?- Hide quoted text - - Show quoted text - You have made it work THANK YOU!!!! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
VBA cell to textbox
ur welcome :-)
" skrev: On Oct 22, 12:55 pm, excelent wrote: Make TextBox1, TextBox2 and TextBox3 on a Form Doubleclick on TextBox1 Insert folowing code except first and last line : Start Form and put searc value in TextBox1 Private Sub TextBox1_Change() On Error Resume Next Me.TextBox2 = "": Me.TextBox3 = "" Me.TextBox2 = Range("A1:A10").Find(Me.TextBox1, LookIn:=xlValues).Offset(0, 1) Me.TextBox3 = Range("A1:A10").Find(Me.TextBox1, LookIn:=xlValues).Offset(0, 3) End Sub " skrev: I'm having an issue if anyone could help. I'm very new to VB/VBA and I'm trying to Search a spreadsheet for specific text in column A, when it finds that data make the cell that data is in the Active cell , then move to column b the same row the data was on and select the text there, Then paste it to a textbox, then it would have to go to column d and do the same, How would i go about doing this?- Hide quoted text - - Show quoted text - You have made it work THANK YOU!!!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
a macro that Formats a textbox based on value in a cell | Excel Worksheet Functions | |||
TextBox control stops displaying linked cell content | Excel Discussion (Misc queries) | |||
pasting textbox value to active cell | Excel Discussion (Misc queries) | |||
Textbox.caption to cell if empty, how? | Excel Worksheet Functions | |||
Textbox.caption to cell if empty, how? | Excel Discussion (Misc queries) |