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

advanced list facility excel

Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Advanced list facility (Excel or VBA)

Advanced list facility (Excel or VBA)

ResolvedVersion 2007

Varuni has attended:
Excel VBA Intro Intermediate course

Advanced list facility (Excel or VBA)

Hi,

I have included some list filters in an excel document (using advanced filters) to restrict what can be typed into my file. However the file is huge despite only having filters and no data.

Is there an alternate way - perhaps by VBA - to include this option of lists.

Using VBA, the ideal is that the person can use drop down boxes to pick customers etc and this populates a row - they should then be able to update other boxes in the same row manually.

Obviously when they go to the next row, they should have the same pop up box....but now amending the new row.

Is this possible?

Thanks!

RE: Advanced list facility (Excel or VBA)

Hello Varuni

okay thanks for your post which we have reviewed with interest.

The outcomes you are trying to achieve are possible however beyond the scope of this forum.

This sort of work can be addressed by one of us spending at least a day with you. This would be consultancy and thus billable. If you would like to investigate this further please contact us directly to discuss.

kind regards

Jacob

Sun 22 Nov 2009: Automatically marked as resolved.

 

Training courses

Training information:

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:

Manually rotating a 3D chart

To manually rotate a 3D chart;
Select the chart (edit mode) and click on one corner of the chart display area. A selection border will appear, using the left mouse button on one of the chart's "corners" (mouse pointer changes to a cross) drag the image which becomes a line representation of the chart (as you begin to drag) and rotate the chart to a view of your choice.
If you dont get it right first time, dont worry, the manoeuver is a little bit tricky.

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.11 secs.