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: 5
Default how to update Listbox of sheetnames if user changes sheetnames?

Hello everyone. Thanks for all your help in the past, and hopefully
someone will be able to get me pointed in the right direction with this
problem too.

I have a userform containing a listbox. the listbox is loaded with the
sheetnames of the workbook. How can I know when/if the user changes
the worksheet names, so that I will then know to update the values of
the listbox so that the listbox always contains the current list of
sheetnames?

Any help is greatly appreciated.

Thanks in advance, and happy programming!

Troy


 
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
Sort Sheetnames when names are Months curiosity_killed_the_cat[_2_] Excel Discussion (Misc queries) 10 November 6th 07 12:07 PM
Allow relative referencing for imbedded sheetnames in formulas Ted Excel Worksheet Functions 1 March 8th 06 10:10 PM
read sheetnames with ADO farmer[_2_] Excel Programming 6 November 2nd 04 04:25 PM
can we copy the sheetnames too? Martyn Excel Programming 5 May 21st 04 10:52 AM
User form with a listbox John Green[_2_] Excel Programming 4 December 30th 03 07:18 PM


All times are GMT +1. The time now is 09:37 PM.

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

About Us

"It's about Microsoft Excel"