Security & Virus | Hardware | Windows XP | Windows Vista | PC Gaming

adding drop down menu to macro

Comment:

I have a macro that I have to type in the pathway to all the different drives and folders for different excel csv files that I wish the marco to run on. My question is, how do I add a drop down menu or explore box to use each time to find the file I want instead of typing them in each time. I'd be grateful for any help. Thank you Jim

Name: Chi Happens
Date: December 2, 2004 at 06:00:04 Pacific

Reply:

You can add user forms by clicking on TOOLS/MACROS/Visual Basic Editor Then INSERT/USER FORM Hope this helps Chi "They mostly come at night...mostly"

0

Key Events in Java in con...

VB and Seqeuntial file

Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.

Summary: Is there anyway to pulling items from the database(in my case, Oracle) and show them drop down menu in perl? I can do this in JSP since JSP code can be reside within HTML code by using , but I have no...

Summary: Sorry if this is in the wrong forum but I think this is the most appropriate one. I have a couple of drop down menu's on a sheet (not on a userform), my problem is I want them to be selected in a set ...

Summary: Hi, I created a drop down menu using java script for users to be able to select certain documents. The page the menu is located is a two frame page. --frame #1 holds the drop down menu --frame #2 is s...