Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
userform and inputboxes
im new to userfroms and please need help with the following code.
all that i done so far is to right click and insert user form and add label1 textbox1 textbox2 textbox3 commandbutton1 label1 needs to display info from sheet1 range c & d & e textbox1 contains a brief description and goes in sheet 1 colum c down(find next open cell downwards) textbox2 contains a date and goes next open cell down in sheet1 colum d textbox3 contains a date and goes next open cell down in sheet1 colum e commandbutton1 = save/ok (puts the data enterd in the three textboxes in the correct range we got a number of specials runing at once but they dont all start or end on the same day. now i need this userform to pop up when the workbook are opened and tell the user what specials are currently running and when it started and when its going to end. on sheet1 it self (called "sheet1") i need the discription in column c down and column d will be the start date and column e the end date. and if possible if the system can see when it ends and the day after it end delete the entry. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Positioning Userforms, InputBoxes | Excel Discussion (Misc queries) | |||
Is there an easy Copy/Paste of a Userform ? (Entire Userform Including tx & cbx's) | Excel Programming | |||
connecting 2 inputboxes and using the autofill | Excel Programming | |||
InputBoxes | Excel Programming | |||
InputBoxes Exceptions | Excel Programming |