Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am creating a userform with hlp from some other forum users.
I have just noticed that when a value is placed intop a textbox, or combobox, the sheet that those values WILL be placed in from the userform are being input in the background as typing of the values is carried out. This is nopt a problem.(But thought application.screenupdating = false) removes this, but If i need to cancel the userform via the Cancel button(unload me), I then have to nagivate to the sheet and manually clear the data the userform was putting in the cells. 1. How do i prevent the data being placed into the sheet UNTIL the OK button is clicked, or 2. How do i have the data entered into the userform cleard from the sheet IF i click cancel ? Corey.... |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Userform to enter values and shown in same userform in list | Excel Programming | |||
Looping procedure calls userform; how to exit loop (via userform button)? | Excel Programming | |||
Activating userform and filling it with data form row where userform is activate | Excel Programming | |||
Access from add_in userform to main template userform.... | Excel Programming | |||
Linking userform to userform in Excel 2003 | Excel Programming |