Home |
Search |
Today's Posts |
#1
|
|||
|
|||
VBA: Update worksheet when txtBox data changes.
This sounds like a great idea. However the cells that I will be pulling from are not static. I want to look up a customer from row 27 with SSN: xxx-xx-xxxx, and then maybe I will look up the next customer on row 45. with ssn: xxx-xx-xxx2. How can I set the control source to a different cell based upon which customer I look up. All of the SSN's will be from the same column, but each ssn is on a diff. row. WILL A CONTROL SOURCE WORK? OR IS THERE A ANOTHER SOLUTION? Mike -- Mcasteel ------------------------------------------------------------------------ Mcasteel's Profile: http://www.excelforum.com/member.php...o&userid=15698 View this thread: http://www.excelforum.com/showthread...hreadid=274237 |
#2
|
|||
|
|||
I have a similar case in the user inputting a number into a textbox. I want this number to be transferred to a named cell in the workbook. This named cell will be in various rows in a fixed column in the WB. My textbox is working correctly, except when cycling through the UserForm, the WB update is always one "cycle" behind the most recently input number. Any ideas? Chuckles123 -- Chuckles123 ------------------------------------------------------------------------ Chuckles123's Profile: http://www.excelforum.com/member.php...o&userid=14948 View this thread: http://www.excelforum.com/showthread...hreadid=274237 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to use outline data (grouped rows) in a protected worksheet? | Excel Discussion (Misc queries) | |||
how do I make a copy of a worksheet and retain formulas but not data | Setting up and Configuration of Excel | |||
Copy data into a NEW worksheet | Excel Discussion (Misc queries) | |||
Reference Data in Moved Worksheet | Setting up and Configuration of Excel | |||
VBA: Update worksheet when txtBox data changes. | Excel Worksheet Functions |