Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
No Name
 
Posts: n/a
Default activate control

If I create a combo box and I click on it....it remains
in design mode ! When I click on it just the resizing
handles appear, the control doesn't drop down or work. I
cannot get it to work .

Help
Matt
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,080
Default activate control

Make sure you get out of design mode by clicking the button with the blue
triangle on the Control Toolbox.
--

Vasant

wrote in message
...
If I create a combo box and I click on it....it remains
in design mode ! When I click on it just the resizing
handles appear, the control doesn't drop down or work. I
cannot get it to work .

Help
Matt



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 79
Default activate control

you created ActiveX control instead of Form control (they are different). To
make it work, show Control Toolbox toolbar (from toolbars), and click the
first button - it switches between design mode (where you are) and run-time.

RADO

wrote in message
...
If I create a combo box and I click on it....it remains
in design mode ! When I click on it just the resizing
handles appear, the control doesn't drop down or work. I
cannot get it to work .

Help
Matt



  #4   Report Post  
Posted to microsoft.public.excel.programming
No Name
 
Posts: n/a
Default activate control

PERFECT !! Thanks MUCH !


Matt


-----Original Message-----
Make sure you get out of design mode by clicking the

button with the blue
triangle on the Control Toolbox.
--

Vasant

wrote in message
...
If I create a combo box and I click on it....it remains
in design mode ! When I click on it just the resizing
handles appear, the control doesn't drop down or work.

I
cannot get it to work .

Help
Matt



.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Process control chart for quality control in exel? Kara Charts and Charting in Excel 2 May 11th 10 05:45 PM
2007 Form Control/ActiveX Control font difference Nikko963 Excel Discussion (Misc queries) 0 April 15th 09 04:21 PM
Excel spin box - no Control tab in Format Control dialong box tocoau Excel Worksheet Functions 7 August 10th 08 03:15 PM
Difference between a Forms Control verus Active-X Control funGT350 Excel Discussion (Misc queries) 6 May 6th 08 11:20 PM
what is code to activate a combo box in control toolbox Pogo Excel Discussion (Misc queries) 1 July 23rd 06 10:41 AM


All times are GMT +1. The time now is 03:44 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"