Call combobox_change function on exit.

**hubert_ii** · 12-22-2009, 08:08 AM

Hi!

I've got a problem. I'm using an activex combobox in excel. It display 4 posible choices, and one of them is "Other". When someone select "other" there is a textbox named "tb" that should be filled. Otherwise tb should be invisible. Combobox change() function looks like that:

Please Login or Register  to view this content.

Apears when I try to close excel - there is a question if I want to save changes and when I answers "Yes" it - somehow - call combobox7_change() function. In that moment textbox "tb" doesn'y exist, so there is an error message

Please Login or Register  to view this content.

Could anyone help me, please? What I'm doing wrong?

**davesexcel** · 12-22-2009, 09:13 AM

Hi,
Do you have any workbook macros?

**hubert_ii** · 12-22-2009, 09:17 AM

Yeah, but I belive they shouldn't make diference. There is only Open() - initialisations of all comboboxes only.

Precisely:

Please Login or Register  to view this content.

**davesexcel** · 12-22-2009, 09:23 AM

You may have to supply a sample workbook that shows the error.

**hubert_ii** · 12-22-2009, 09:34 AM

Ok - i've send you an email.

**romperstomper** · 12-22-2009, 11:32 AM

Is your combobox linked directly to cells on a worksheet?

**hubert_ii** · 12-23-2009, 02:54 AM

No - it's created in a workbook section as you can see over that post. It "comunicates" only whith that "TB" textbox in a change() function.

**Andy Pope** · 12-23-2009, 05:53 AM

The attached works for me using your code.

One difference I noticed is that for me the Change event is a private sub.
Yours is Public, did you create that yourself in a standard code model?

**hubert_ii** · 12-23-2009, 07:48 AM

Hi!

Unfortunately I experience same problem with that project, that you have attached. When I open the file, change something and then i try to close file, there very same alert appears...

Below you could find short screencast.
http://www.speedyshare.com/files/199...0170524844.avi

**Andy Pope** · 12-23-2009, 08:04 AM

so is the textbox named tb?

As already requested, post your example file.

**hubert_ii** · 12-23-2009, 08:16 AM

I've send it to you in a private message.

**Andy Pope** · 12-23-2009, 08:28 AM

Your file works as expected.

Open you file and go to the VBE. Try compiling the project.

Menu, debug > Compile project. Do you get error message?

**hubert_ii** · 12-23-2009, 08:40 AM

No - in fact I don't get any message. Compilation didn't solve the problem either...

**Andy Pope** · 12-23-2009, 08:59 AM

Hard to know what the problem is then as both test files work for me.
And for you the file does not report error when compiling but then stops reporting error on close.

**hubert_ii** · 12-23-2009, 09:05 AM

Ok - thanks for trying. It must be something with my environment then...
Probably I work it somehow out.

Thanks a lot and Marry Holly Days!

Call combobox_change function on exit.

LinkBack

Thread Tools

Rate This Thread

Display

Call combobox_change function on exit.

Re: Calling combobox_change function on exit.

Re: Calling combobox_change function on exit.

Re: Calling combobox_change function on exit.

Re: Calling combobox_change function on exit.

Re: Calling combobox_change function on exit.

Re: Calling combobox_change function on exit.

Re: Calling combobox_change function on exit.

Re: Calling combobox_change function on exit.

Re: Calling combobox_change function on exit.

Re: Calling combobox_change function on exit.

Re: Calling combobox_change function on exit.

Re: Calling combobox_change function on exit.

Re: Calling combobox_change function on exit.

Re: Calling combobox_change function on exit.

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions