Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a UserForm with MultiPages, ComboBoxes, and Captions.
I have it set up right now so that when I select a new value for the ComboBox, the ComboBox_Change() runs a Caption update to format the new value of a cell in that caption with the proper number of decimals (2). Here is the code that I have for the ComboBox_Change(): Private Sub ComboBox1_Change() With UserForm1.MultiPage1.Pages(0).MultiPage2.Pages(1) Worksheets("Worksheet1").Cells(13, 5).Value = .ComboBox1.Value .labelG16.Caption = FormatNumber((Worksheets("Worksheet1").Cells(16, 7).Value), 2) End With End Sub The Error I get when this runs is: "Error "438": Object doesn't support this property or method." When I hit "debug" it sends me to the ..labelG16.Caption line. Does anybody have any ideas with this? I really appreciate the help! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Weird error | Excel Programming | |||
Very weird error | Excel Worksheet Functions | |||
Combobox_change does not repond? | Excel Programming | |||
Weird error | Excel Programming | |||
ComboBox_Change sub runs unexpectedly | Excel Programming |