Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
user form, code placement
morning all.
I've made the initial aspects of a user form. In it I've placed 10 combo boxes. I've found samples to use so I could populate my boxes with my desired contents. When I click on run, in the VBE, for the user form, my combo-boxes are not populated. Now, my question is-- What do I need to initiate the population of them when the userform loads? Thank you in advance. Best. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
user form, code placement
You can load them with the RowSource/ListFillRange method or with the
AddItem method as part of the UserForm_Initialize event code. "Steve" wrote in message ... morning all. I've made the initial aspects of a user form. In it I've placed 10 combo boxes. I've found samples to use so I could populate my boxes with my desired contents. When I click on run, in the VBE, for the user form, my combo-boxes are not populated. Now, my question is-- What do I need to initiate the population of them when the userform loads? Thank you in advance. Best. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
user form, code placement
You can access the UserForm code module by right clicking on the form in
design mode, then select View Code from the pop up menu. Click in the declarations panel of the code window to select the Initialize event and it will put the correct procedure name and end lines in the code window for you. "Steve" wrote in message ... morning all. I've made the initial aspects of a user form. In it I've placed 10 combo boxes. I've found samples to use so I could populate my boxes with my desired contents. When I click on run, in the VBE, for the user form, my combo-boxes are not populated. Now, my question is-- What do I need to initiate the population of them when the userform loads? Thank you in advance. Best. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
user form, code placement
Hi JLG,
Ok, I did as you said, and see nothing that shows an initialize event. When you say declarations, you're referring to the right side drop down that lists all of the procedures in a given "module," correct? Then, I always keep my properties pane open, and have been through that a few times-- no initialize. "JLGWhiz" wrote: You can access the UserForm code module by right clicking on the form in design mode, then select View Code from the pop up menu. Click in the declarations panel of the code window to select the Initialize event and it will put the correct procedure name and end lines in the code window for you. "Steve" wrote in message ... morning all. I've made the initial aspects of a user form. In it I've placed 10 combo boxes. I've found samples to use so I could populate my boxes with my desired contents. When I click on run, in the VBE, for the user form, my combo-boxes are not populated. Now, my question is-- What do I need to initiate the population of them when the userform loads? Thank you in advance. Best. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
user form, code placement
DOH!
I found it. What do I place in there next? "JLGWhiz" wrote: You can access the UserForm code module by right clicking on the form in design mode, then select View Code from the pop up menu. Click in the declarations panel of the code window to select the Initialize event and it will put the correct procedure name and end lines in the code window for you. "Steve" wrote in message ... morning all. I've made the initial aspects of a user form. In it I've placed 10 combo boxes. I've found samples to use so I could populate my boxes with my desired contents. When I click on run, in the VBE, for the user form, my combo-boxes are not populated. Now, my question is-- What do I need to initiate the population of them when the userform loads? Thank you in advance. Best. |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
user form, code placement
ok. I'm good here.
JLG, Thank you for your help. Best. "JLGWhiz" wrote: You can access the UserForm code module by right clicking on the form in design mode, then select View Code from the pop up menu. Click in the declarations panel of the code window to select the Initialize event and it will put the correct procedure name and end lines in the code window for you. "Steve" wrote in message ... morning all. I've made the initial aspects of a user form. In it I've placed 10 combo boxes. I've found samples to use so I could populate my boxes with my desired contents. When I click on run, in the VBE, for the user form, my combo-boxes are not populated. Now, my question is-- What do I need to initiate the population of them when the userform loads? Thank you in advance. Best. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Code, is user form open | Excel Programming | |||
user form-vba code | Excel Programming | |||
How can I duplicate a user form and all code? | Excel Programming | |||
User Form Code | New Users to Excel | |||
determining coordinates for screen placement of user form | Excel Programming |