Combo box wizrd steps

[Lou_Reed]

When checking a db written by another person, is it possible to see the VBA code or Macro steps when looking into a existing combo box written by someone else?



The way I do it now is try several sequences of steps and then if my end result looks like the combo box in question, then that must be the steps that were used to get said combo box.

I know of no other way. O

f course, one must record each set of steps so when you get the box that you want you know the steps that were used to get it.

Any help appreciated. Thanks in advance.

Respectfully,

Lou Reed

[ranman256]

select the combo and view the properties, events tab.
usu the afterupdate event is used. click the elipsis on that event to see the code.

[John_G]

If the combo box was actually created by VBA or a macro, no.

Your best option is to learn what the properties and events in combo boxes are and what they do, then set the properties and code the events to achieve what you want. Looking at the properties of existing combos is not much help when you don't know what the properties do. Use the context-sensitive F1-Help to find more detailed information on the properties.

As time goes on you will find that working with combos (or any other control) becomes easier as you get used to them.

[orange]

Lou,
There are several articles and youtube videos on a variety of subjects. Have you not investigated these?

Here is one on combobox