View Single Post
  #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