Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 8
Default List Box or combo box into a cell

hi,

is there any way by which i can convert a particular cell, say A1 to list
box or combo box without using VBA control tools. i saw this type of
conversion in Autofilter option.

reg
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5,302
Default List Box or combo box into a cell

Hi Aken,

Look at using Data Validation.

If you are not familiar with Excel's Data Validation featute, see Debra
Dalgleish's tutorial at:

http://www.contextures.com/xlDataVal01.html

---
Regards,
Norman



"aken" wrote in message
...
hi,

is there any way by which i can convert a particular cell, say A1 to list
box or combo box without using VBA control tools. i saw this type of
conversion in Autofilter option.

reg



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 8
Default List Box or combo box into a cell

thnaks it helped me to get the work done.

"Norman Jones" wrote:

Hi Aken,

Look at using Data Validation.

If you are not familiar with Excel's Data Validation featute, see Debra
Dalgleish's tutorial at:

http://www.contextures.com/xlDataVal01.html

---
Regards,
Norman



"aken" wrote in message
...
hi,

is there any way by which i can convert a particular cell, say A1 to list
box or combo box without using VBA control tools. i saw this type of
conversion in Autofilter option.

reg




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
validation list or combo box dependant on cell value Richard Edwards[_2_] Excel Worksheet Functions 4 February 26th 09 01:04 PM
How to reference cell created from dropdown list in a combo box? Vishwas Excel Discussion (Misc queries) 1 December 2nd 08 02:41 PM
drop-down list(or combo-box) for the cell ali Excel Discussion (Misc queries) 2 September 12th 07 01:05 PM
Can I have automatic cell population while using combo list? rick Excel Discussion (Misc queries) 7 March 28th 06 05:28 AM
Combo Box Value List Todd[_7_] Excel Programming 1 September 17th 03 02:49 AM


All times are GMT +1. The time now is 10:21 PM.

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

About Us

"It's about Microsoft Excel"