PC Review


Reply
Thread Tools Rate Thread

Create Menu Macro

 
 
TexYankee
Guest
Posts: n/a
 
      10th Jan 2008
I have used Quattro Pro for years and I’m having difficulty adjusting to
Macros in VBA. I need help creating an Excel 2003 Expense macro. The macro
should popup a menu with a list of my expense categories Office, Supplies,
Repairs, etc. By typing the first letter of the word or scrolling down, I go
to Supplies, a new menu pops up with list of Suppliers: ABC Company, DEF
Company, GHI Company, etc. I select the company and the macro inputs the
Company name Always Starting in cell A22, moves over one cell to B22 inputs
category Supplies, moves over to next cell to allow input by the user of the
Amount. After User entering Amount the macro moves back (left) 2 cells and
down 1 row. Ready to input next expense one line down.
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Create MACRO for menu dropdown in WORD yendorian Microsoft Access Macros 1 8th Jan 2010 01:12 PM
Create Shortcut Menu from Macro Training Spec. Microsoft Access Macros 0 10th Jun 2008 05:07 PM
How to create pop menu in macro ? broogle Microsoft Excel Programming 1 16th Dec 2004 12:16 AM
RE: Create macro to restore toolbars and menu? =?Utf-8?B?TGluZGEgSA==?= Microsoft Word Document Management 1 8th Jul 2004 09:29 PM
Re: Create macro to restore toolbars and menu? Dayo Mitchell Microsoft Word Document Management 0 7th Jul 2004 06:04 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 09:32 AM.