Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
module related
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
module related
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? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
module related
What sort of combobox, and where is your module?
If it is a forms combobox, the assigned macro should go in a standard code module. If it is a control toolbox combo, you should check it the control's click event. -- HTH RP (remove nothere from the email address if mailing direct) "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? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
module related
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? |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
module related
It is a control toolbox combo. I just inserted a module. Is this incorrect?
The combo box will effect other objects on the worksheet. The module isn't reading the combo box so i know it won't read the other objects as well. Is there a similar way to do this in a module or should i just make it a procedure for the worksheet location? "Bob Phillips" wrote: What sort of combobox, and where is your module? If it is a forms combobox, the assigned macro should go in a standard code module. If it is a control toolbox combo, you should check it the control's click event. -- HTH RP (remove nothere from the email address if mailing direct) "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? |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
module related
No, you need to tie to the click event. In the controls toolbox, click the
blue-green triangle icon (design mode). Then double-click the combobox, this will create a template click event. Put you code in their. Back on the worksheet, take it out of design mode. -- HTH RP (remove nothere from the email address if mailing direct) "Monique" wrote in message ... It is a control toolbox combo. I just inserted a module. Is this incorrect? The combo box will effect other objects on the worksheet. The module isn't reading the combo box so i know it won't read the other objects as well. Is there a similar way to do this in a module or should i just make it a procedure for the worksheet location? "Bob Phillips" wrote: What sort of combobox, and where is your module? If it is a forms combobox, the assigned macro should go in a standard code module. If it is a control toolbox combo, you should check it the control's click event. -- HTH RP (remove nothere from the email address if mailing direct) "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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
CLASS MODULE & SIMPLE MODULE | Excel Discussion (Misc queries) | |||
code in module A to not execute a Worksheet_SelectionChange sub of another module | Excel Discussion (Misc queries) | |||
Calls from sheet module to ThisWorkbook module | Excel Programming | |||
arrays - module to module | Excel Programming | |||
Variable from a sheet module in a class module in XL XP | Excel Programming |