Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 270
Default Drop down list/Combo box?

Hi
I have a range of cells C6:K6 which contains numbers from 3 to 9.
In a second range C18:K18 I would like to have the following (if possible):

If C6 = 3 then C18 = "X" otherwise if C6 3 then Insert a drop-down box
with values "Yes" and "No".

Can this be done?

Sandy
ps I know I posted this on Public.Excel but I then thought this was a more
appropriate section


  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 35,218
Default Drop down list/Combo box?

Check your other post.

Sandy wrote:

Hi
I have a range of cells C6:K6 which contains numbers from 3 to 9.
In a second range C18:K18 I would like to have the following (if possible):

If C6 = 3 then C18 = "X" otherwise if C6 3 then Insert a drop-down box
with values "Yes" and "No".

Can this be done?

Sandy
ps I know I posted this on Public.Excel but I then thought this was a more
appropriate section


--

Dave Peterson
  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 270
Default Drop down list/Combo box?

I've done so Dave - Thanks

"Dave Peterson" wrote in message
...
Check your other post.

Sandy wrote:

Hi
I have a range of cells C6:K6 which contains numbers from 3 to 9.
In a second range C18:K18 I would like to have the following (if
possible):

If C6 = 3 then C18 = "X" otherwise if C6 3 then Insert a drop-down box
with values "Yes" and "No".

Can this be done?

Sandy
ps I know I posted this on Public.Excel but I then thought this was a
more
appropriate section


--

Dave Peterson



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
Using Drop Down List or Combo Box Dana M Excel Worksheet Functions 9 January 30th 09 02:58 AM
drop-down list(or combo-box) for the cell ali Excel Discussion (Misc queries) 2 September 12th 07 01:05 PM
Combo drop down list art Excel Programming 6 November 28th 06 08:35 PM
Drop Down List Box, Combo Box ExcelUser777 Excel Discussion (Misc queries) 4 April 9th 06 12:51 AM
Drop down list or combo box help needed metrueblood Excel Discussion (Misc queries) 1 January 12th 05 09:25 PM


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

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"