Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Userform Canellation.
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.... |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Userform Canellation.
Hi,
Please give us your code so we can clearly understand it. if you are putting your code to transfer the data under the textbox or combobox change event it will not write it your cell unless you press your OK button. If I have textbox1 and commandbuuton1 in a user form then The value of textbox1 will be entered in sheet1 range A1 only when i press the commandbutton1 using the following code Private Sub CommandButton1_Click() Sheets("Sheet1").Range("A1") = TextBox1.Value End Sub Thanks Corey wrote: 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.... |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Userform Canellation.
Change your code to write to the sheet on an explicit action, such as
clicking a commanbutton, not as it is entered. -- --- HTH Bob (change the xxxx to gmail if mailing direct) "Corey" wrote in message ... 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.... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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 |