Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi Merjet - Thanks for your help.
All the checkboxes do, once they are clicked, is update a value on a sheet and then add that value to a textbox on the form. Me.MultiPage1.Pages(1).TextBox13.Value = Format(Sheets("Customer").Range("L24").Value, "£0,00") Although this only begins to work once a check box is clicked twice (not a doubleclick). My textbox is set to £0,00 when the form activates. Setting a checkbox to TRUE should then change the textbox to a new value e.g £500. But it only updates the textbox once the checkbox is set to FALSE - which is obviously wrong. Any suggestions? Trevor "merjet" wrote: Change: .MultiPage1.Pages(1).CheckBox(i) = False To: .Controls("CheckBox" & i) = False Regarding the 2nd question, maybe you can send each Checkbox_Click event to one common Sub. But it's impossible to say w/o knowing what each one does. Hth, Merjet |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Saving values in a multipage form | Excel Programming | |||
checkbox on form reset from checkbox on sheet | Excel Programming | |||
Color in Multipage Form | Excel Programming | |||
multipage form | Excel Programming | |||
Duplicate Values on Multipage form | Excel Programming |