module related
Can you change the location of objects on the sheet without specify the new
location for each one? Probably not. If you are moving them as a group,
you might try group them and moving the group.
--
Regards,
Tom Ogilvy
"Monique" wrote in message
...
I have several objects that be changed according to the selection in the
combo box...
Dim mPriceLeft As Integer
mPriceLeft = 39.75
If cmbPriceType.Value = "Restored" Then
lblResPriceType.Top = 235.5
lblResPriceType.Left = 15.75
chkRDPType.Top = 246.75
chkRDPType.Left = mPriceLeft
chkOWSPType.Top = 262.5
chkOWSPType.Left = mPriceLeft
end if
end sub
There are a lot more variables. Is there a similar way than doing the
below?
Thanks.
"Tom Ogilvy" wrote:
Sheet1.Combobox1.Value
Worksheets("Sheet1").OleObjects("Combobox1").Objec t.Value
--
Regards,
Tom Ogilvy
"Monique" wrote in message
...
I have created a module that will handle when a change occurs to the
excel
worksheet in a combo box.
Depending on the selection value in the combo box, it will go to the
module
and change the format of the worksheet.
The problem is the module is not recognizing the combo box.
How can the module recognize the objects that are related to the
worksheet?
|