Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

data validation list box

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Data Validation (List box)

Data Validation (List box)

ResolvedVersion 2003

Mahesha has attended:
Excel Advanced course
Excel VBA Intro Intermediate course

Data Validation (List box)

How to create one list box (on the header) which will input into onto the activated cell in that column selected below.

RE: Data Validation (List box)

Dear Mahesha

Thank you for attending Excel Advanced course!! I hope you enjoyed the course and benefited from it.


I remember you asking me this question.

I would request you to provide me with an example so that I know exactly what you are seeking.

I can see that you are doing VBA on 23 April and I am pretty sure if your query cannot be resolved with various Functions of Excel then it can be resolved by VBA.

For me to try to look for a solution for you I need you to further clarify your query by providing me with some example please!!

Kindest Regards


Rajeev Rawat
MOS Master Instructor 2000 and 2003
MCAS Master Instructor 2007
MCT

RE: Data Validation (List box)

Hi Mahesha,

Did you find out how to do this on your VBA course?

If not, have you sent any examples to Rajeev?

This question has now been left unattended for a while.

We like to keep down the large number of active forum posts we receive.

As we are waiting for your response for further information to help resolve your issue, we will be automatically marking this question as resolved in the next 5 days (unless you post a follow-up within that time).

We look forward to hearing from you.

Thank you.
Regards, Rich

Wed 20 May 2009: Automatically marked as resolved.

 

Training courses

Training information:

See also:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.

Excel tip:

Applying and removing border from cell in Excel 2010

Did you know the shortcut key for applying and removing the outline border for a cell?

CTRL+SHIFT+& Applies the outline border to the selected cells.
CTRL+SHIFT_ Removes the outline border from the selected cells.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.