Macro to load userform from combobox

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Robbyn - 06 Aug 2005 23:19 GMT

Hi,

I'm using a combobox from the forms toolbar which, when a selection is made,
should load a userform. I've placed the code in a module for the document to
load the form and in "on exit" of the properties of the combobox I've put the
name of the macro. However, the userform doesn't load. What am I doing
wrong?

Reply to this Message

Robbyn - 06 Aug 2005 23:47 GMT

Nevermind. It's working now, but no idea why. :)

> Hi,
>
[quoted text clipped - 3 lines]
> name of the macro. However, the userform doesn't load. What am I doing
> wrong?

Reply to this Message

Helmut Weber - 07 Aug 2005 09:07 GMT

Hi

may it will again stop working tomorrow.

I've heard a lot recently about bugs in MSForms 2.0,
specially about on enter in and on exit from comcoboxes.

Greetings from Bavaria, Germany

Helmut Weber, MVP WordVBA

Win XP, Office 2003
"red.sys" & Chr$(64) & "t-online.de"

Reply to this Message