Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Inserting TextBox1 Value into Conditional Column/Row4
Sheets("Team Data").Range("X2").Value & "4" = TextBox1.Value
I am trying to write a code(located above) that will insert TextBox1 value into a cell on Row4. The Column Letter will always be located in cell X2. For instance, if the value in cell X2 is "W", then I need the code to enter TextBox1.Value into cell W4. Here is the code I have so far. Right now the code is coming up color red and saying compile error: expected expression. I can not figure out what I'm doing wrong. Can anyone tell me what the correct code would be? Thank you Todd Huttenstine |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Inserting text in column dependant on another column | Excel Worksheet Functions | |||
Inserting a new column affects conditional formatting | New Users to Excel | |||
TextBox1 to Label4 | Excel Discussion (Misc queries) | |||
Highlighting Textbox1 Value when form initializes. | Excel Programming | |||
UserForm1.Textbox1.SetFocus Question | Excel Programming |