alliejane
08-14-2007, 03:59 PM
Well...sorta. I have a sample user form that someone sent me so that I can copy/learn from it. I also have a book where I'm reading the chapters about user forms. I, however (being blonde) either can not find the answer to my questions or don't know how to ask it properly in the help screens.
The user form has 2 text boxes that are dates. The dates are entered and are then updated on the worksheet.
a) How do I define which worksheet is to be updated with the values in the text boxes? The sample I have is just one page, where my application has 4 sheets.
b) after I figure out how to put the values in the correct worksheet, is it correct to assume that the Data/ControlSource value is where the value will be placed? My sample has data/controlsource = SecondDate and SecondDate is a name in the sample worksheet.
Thanks!
The user form has 2 text boxes that are dates. The dates are entered and are then updated on the worksheet.
a) How do I define which worksheet is to be updated with the values in the text boxes? The sample I have is just one page, where my application has 4 sheets.
b) after I figure out how to put the values in the correct worksheet, is it correct to assume that the Data/ControlSource value is where the value will be placed? My sample has data/controlsource = SecondDate and SecondDate is a name in the sample worksheet.
Thanks!