Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Update Form from spreadsheet
Hello All,
I have a user form that is used to insert values on a specific page in a workbook. That part works fine. I have been asked to add data that is the result of previous entries. eg text box 1 is used to enter new data text box 2 would show a value that is in the spreadsheet How do I load the form and populate text box2 prior to data entry? Thanks John |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Update Form from spreadsheet
in the form initailize event put......
text_box2.value = Sheets("Name").Range("A1").value -- Cheers Nigel "Will Tuck" wrote in message news:OLd3e.122937$ZO2.96292@edtnps84... Hello All, I have a user form that is used to insert values on a specific page in a workbook. That part works fine. I have been asked to add data that is the result of previous entries. eg text box 1 is used to enter new data text box 2 would show a value that is in the spreadsheet How do I load the form and populate text box2 prior to data entry? Thanks John |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
record update VBA form | Excel Discussion (Misc queries) | |||
excel form. Need data extracted to spreadsheet each time a form co | Excel Discussion (Misc queries) | |||
Data Update Form | Excel Programming | |||
Form Update before ProcRuns | Excel Programming | |||
using vba to update vba form | Excel Programming |