Drop down boxes in worksheet cells

  • Thread starter Thread starter Mark King
  • Start date Start date
M

Mark King

Hi,

Is there any way I can have a drop down box with four selections in each and
every cell from ranges (G5:G30).

Once a user makes a selection the contents are to be placed in their
appropriate cells that they were selected from.

Many thanks for your help in advance,
Mark
 
You will need to go to the Data menu and select 'Validation'. This wil
bring up a dialog box that allows you to specify the contents, allowin
values from a list for example. Once you setup this validation for th
first cell, grab the bottom right anchor of the cell and drag it dow
the range you want. Good luck
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

go to specific cell using drop down box 4
Drop Down Box 7
Drop Down Box 1
Drop Down box 1
Select Case problem when hitting the Delete key 2
Insert new row with drop-down box but problem with cell linkreferring to the original drop-down box 2
Choosing a drop-down menu selection returns value to another cell 2
VBA set thick borders around non empty cells in range 0

Back
Top