Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 10
Default Using a combo or list box to select a statement

Hi,

I want to use a combo or list box to select a statement from a list of
statements in a selected cell.
What is the best way to do this? Can it be done by using a look up statement
or will I have to use a combo or list box?

Graeme.
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 10,593
Default Using a combo or list box to select a statement

Sounds like data validation,

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

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Jurrasicway" wrote in message
...
Hi,

I want to use a combo or list box to select a statement from a list of
statements in a selected cell.
What is the best way to do this? Can it be done by using a look up

statement
or will I have to use a combo or list box?

Graeme.



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
select macro within combo box or list box to Karin Excel Discussion (Misc queries) 2 June 25th 08 01:49 AM
Select all data in column and list in form combo box burl_rfc Excel Programming 5 April 11th 06 02:47 AM
Filtered list for Combo Box ListFillRange - Nested Combo Boxes DoctorG Excel Programming 3 February 23rd 06 12:15 PM
IF Statement for Combo Box List [email protected] Excel Programming 0 September 22nd 05 02:26 PM
How do I set up a combo box to select one value but pas an other . exkiller Excel Programming 1 January 4th 05 07:06 PM


All times are GMT +1. The time now is 07:02 PM.

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"