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: 39
Default input worksheet name

I want the user to enter a row number - easy:

RowSou = InputBox("Enter source row")

But I also want the user to specify which sheet the row number is on. I
could have the user enter the sheet name manually in another input box, but
with the risk of typos or misspelling i'm looking for a nicer way for the
user to select the correct sheet. Please supply any code you may think could
do the trick.

Thank you.
The Doctor
 
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
Tabbing through input worksheet BJ&theBear Excel Discussion (Misc queries) 2 April 6th 10 04:48 PM
How do I use a worksheet name as an input variable to a formula? tonymotion Excel Discussion (Misc queries) 6 September 5th 07 04:37 AM
Input data from one worksheet to another Yendorian Excel Discussion (Misc queries) 0 June 19th 07 09:06 AM
Input data from one worksheet to another stud.poser Excel Programming 0 July 15th 04 02:45 PM
Input Form on Worksheet 1, Data on Worksheet 2 Jim in Spokane Excel Programming 1 April 4th 04 03:24 PM


All times are GMT +1. The time now is 12:13 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"