data validation list box

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

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

Data Validation (List box)

resolvedResolved · Medium Priority · Version 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:

Editing Formulas in Excel Cells

Although people like to edit a formula in the Formula bar, you can also edit a formula in the cell.

To do this select the cell and press "F2". This puts Excel into Edit mode, and you can move around in the cell and make any necessary changes.

Double-clicking the cell also puts Excel in Edit mode.

View all Excel hints and tips


Server loaded in 0.09 secs.