Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a user form with 2 pages "invoice address" and "delivery address" the
user enters details into some text boxes which then sends info to the spreadsheet. On occasion the invoice details and the delivery details are the same so i added a check box at the bottom of the form end entered the following code: Private Sub CheckBox1_Click() If CheckBox1.Value = True Then TextBox11.Value = TextBox1.Value textbox12.value=textbox2.value End If end sub thh problem id when you click the box it only filles in textbox11 to get it to fill in textbox12 you have to click the checkbox again. Can anyone help? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Click event on menu item is lost after first time firing of the event | Excel Programming | |||
userform label double-click goes to click event | Excel Programming | |||
On Click Event | Excel Programming | |||
Click event to run only once | Excel Programming | |||
Click event to run only once | Excel Programming |