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: 81
Default Attaching Macros To Items In a List Box

I have a list box ListBox1 on a worksheet called Data. The list box fill
range is List!A1:A12 where I have a list of months. I have 12 worksheets
with each month for the worksheet name. When a user selects a month from the
list box I would like to call the corresponding worksheet and hide the other
eleven. Is there an easy way to do this. I am not experienced with writing
macros...only recording them.
 
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
Attaching a 2 item list to a cell / drop-down? Enrique Mahecha Excel Discussion (Misc queries) 8 December 22nd 05 06:30 PM
Attaching toolbars to spreadsheet, but macros do not follow? JB Excel Programming 3 August 13th 04 09:48 PM
Macros in a template run from Custom Toolbar attaching to wrong file. Linda Excel Programming 4 May 17th 04 11:46 PM
Problems Attaching Macros to Command Button Jim[_33_] Excel Programming 1 October 23rd 03 08:41 AM
Attaching Macros to Custom Buttons Jack O Excel Programming 0 August 21st 03 10:49 PM


All times are GMT +1. The time now is 05:46 AM.

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"