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: 3,101
Default connecting 2 inputboxes and using the autofill

What I am trying to do is use the data entered in one inputbox with the data
entered from a 2nd input box. I an trying to make a macro so that the user
can make consecutively numbered labels with the push of a button, so the
button would bring up the 1st inputbox asking what number to start at and
then a 2nd inputbox would appear asking how many to make (how far down the
list to go). I can get the 2 inputboxes to pop up and I can get the boxes to
dump the numbers into a sheet. I know you can use the autofill function but
I am not sure how to connect them all so that the user can just enter the 2
numbers and the macro will fill to the appropriate number. Any help would be
great! Thanks
 
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
Positioning Userforms, InputBoxes Pflugs Excel Discussion (Misc queries) 1 July 10th 07 06:12 PM
InputBoxes Sean Excel Programming 2 July 19th 06 06:09 PM
Autofill: Need to autofill one week block, (5) weekday only into cells. dstock Excel Discussion (Misc queries) 1 June 17th 05 08:21 PM
Q. Autofill question: Can I autofill alpha characters like I can numbers? George[_22_] Excel Programming 5 August 7th 04 10:33 AM
InputBoxes Exceptions ianripping[_42_] Excel Programming 3 April 8th 04 09:34 PM


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