ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Clicking on listbox control displays code - why? (https://www.excelbanter.com/excel-programming/309832-clicking-listbox-control-displays-code-why.html)

Mark[_51_]

Clicking on listbox control displays code - why?
 
I have developed a spreadsheet in Excel 2002 that contains 10 ActiveX
listbox controls (1 per cell). I have only one user that reports when
they click on the listbox, that instead of showing the list of values,
the VBA code I developed to support this ActiveX control appears
instead. This user is using Excel 2000 SP3. BTW, other users are
working with Excel 2000 w/o any problems.

Any help would be appreciated.

TIA
Mark

Tom Ogilvy

Clicking on listbox control displays code - why?
 
the user appears to be in design mode.

--
Regards,
Tom Ogilvy

"Mark" wrote in message
om...
I have developed a spreadsheet in Excel 2002 that contains 10 ActiveX
listbox controls (1 per cell). I have only one user that reports when
they click on the listbox, that instead of showing the list of values,
the VBA code I developed to support this ActiveX control appears
instead. This user is using Excel 2000 SP3. BTW, other users are
working with Excel 2000 w/o any problems.

Any help would be appreciated.

TIA
Mark





All times are GMT +1. The time now is 07:36 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com