Message 1 of 2
insert blocks via combobox

Not applicable
12-10-2008
09:15 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report
Hello guys,
I'm beginning a project where I need to insert certain blocks depending on what selection is made in a combobox.
The items in the combobox do not match the names of the blocks.
For example, The combo box contains Red, White, Blue, Green.
Red will insert BlockA .
White will insert BlockB.
Blue will insert BlockC
Green will insert BlockD
What is the best way to accomplish this? I'm new to VBA and I am certainly unfamiliar with inserting blocks.
As always, any advice is greatly appreciated.
Thanks,
Xi
I'm beginning a project where I need to insert certain blocks depending on what selection is made in a combobox.
The items in the combobox do not match the names of the blocks.
For example, The combo box contains Red, White, Blue, Green.
Red will insert BlockA .
White will insert BlockB.
Blue will insert BlockC
Green will insert BlockD
What is the best way to accomplish this? I'm new to VBA and I am certainly unfamiliar with inserting blocks.
As always, any advice is greatly appreciated.
Thanks,
Xi