LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
Tim Tim is offline
external usenet poster
 
Posts: 408
Default Selection from drop-down box

Hi all,

Users of my excel workbook need to complete a calculation sheet with
account-numbers. Though, I want to limit the input possibilities.

An account can only be chosen once and should not be proposed when already
selected. I know what is possible with €˜validation.

Does anybody know if this would be possible with a pop-up box that show all
available accounts? In the pop-up box, the user should be able to select the
account and move this to a cell in a calculation sheet . The selected account
should removed from the pop-up box.

Many thanks!
Rgs, Tim
 
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
Create new drop down from previous drop down selection Supe Excel Discussion (Misc queries) 3 January 19th 07 10:26 PM
How to 'copy' a drop down box selection? Joni Excel Discussion (Misc queries) 5 June 30th 06 08:30 AM
Selection of Drop down list that allows you to go to a particular cell Daphne Excel Worksheet Functions 2 June 14th 06 09:54 AM
drop down selection determines other drop down content lskelton Excel Discussion (Misc queries) 1 November 1st 05 11:14 PM
Drop Down - Jump to selection Rosa Excel Worksheet Functions 2 September 30th 05 07:20 PM


All times are GMT +1. The time now is 10:57 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"