LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 33
Default VBA Code to Create a Toggle Button

I am trying to create code that will look in a given path and add a toggle
button (or command button) to an existing user form for each file in the
folder that the path referenced. I would like the toggle button that is
added to be linked to code that will open the file that the button
references. For example if "MyFolder" contains:

Abc.xls
Def.Doc
Ghi.txt

I would like the code to create a button on "MyUserform" for each of the 3
files, that will open the file when the userform is activated and the
particular button is clicked. I envision the code that populates the
userform being in the "ThisWorkbook" module and running when the workbook is
opened.

Thanks for any help you can give me
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Command button to toggle worksheet event code on / off? Fred[_2_] Excel Discussion (Misc queries) 15 July 31st 07 11:50 AM
How to create a toggle button on the menu? OKLover Excel Programming 4 July 10th 05 03:51 PM
toggle button & event code Bob Umlas[_3_] Excel Programming 0 April 14th 05 08:22 PM
Why does this code not create a button when called??? Simon Lloyd[_532_] Excel Programming 3 August 16th 04 02:31 AM
Create Command Button from Code Bruce B[_2_] Excel Programming 0 July 14th 03 02:01 PM


All times are GMT +1. The time now is 07:17 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"