Data Validation Drop Down Using VBA?

E

egun

Is there a way to programmatically cause a drop-down list in a cell with
validation to show? On one of my worksheets, if the user enters a certain
value in one cell, another cell is populated with a list of titles the user
must choose from. I would like that list to automatically show ("drop down")
to remind the user to select something.

Thanks,

Eric
 
M

MeistersingerVonNurnberg

Hi -

Why not just use a visual cue instead. Maybe change the color of the cell in
question when the other value is entered.

You could either do this with code to just change the range /cell interior
color, or you could setup conditinal formats prior to any macros running, or
you could do a combination of both.

As well, you can setup your dv lists to prompt the user on input or invalid
entry. This would require the user to be in the cell w the list though.
 

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

Validation Drop Down 2
Cell Validation "Ingnore Blanks" doesn't work 1
VBA and Validation Lists 2
using the if statement with data validation 2
Cell Select 5
Data Validation 8
Data Validation Drop-Down List Problem 8
Dynamically adding an in-cell drop-down list (i.e. Validation Object) to a cell? 5

Top