Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using user form to change cell value on worksheet
Hi,
I have a user form with the following code for looking up a cell value on my worksheet: TextBox2.Text = Application.VLookup(CDbl(ComboBox1.Text), _ Worksheets("Blending Details").Range("A2:Z500"), 2, False) Now if I was to type in a different value in text box 2 how would I write a code that would send the updated value back to the worksheet(("Blending Details").Range("A2:Z500"), 2,)? Regards gregork |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I fill a cell in a user form from a selection on same form? | Excel Discussion (Misc queries) | |||
User form to change manual field filter in pivot table | Excel Discussion (Misc queries) | |||
Detecting Input Change on User Form | Excel Programming | |||
Edit worksheet while a user form is on? | Excel Programming | |||
Activating a worksheet with a user form open on the screen | Excel Programming |