Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello,
I'm trying to create a VBA Macro where the user presses a button on a spreadsheet which will start a userform. The userform will ask the user for specific data regarding a spreadsheet with the following data: Row Acct Seq Acct-Descr 1 4111 Stuff 2 4112 Stu 3 4112 1 Stuff 4 4112 2 Stuff2 5 4112 3 Stuff3 6 4113 Stuffs 7 4114 Stuffed The Row # is the rows normally displayed in Excel on the very left. I would like to the form to ask what Row # the user would like to insert ABOVE, what # they want in the acct #, what # they want for a seq # and what the Account Description should be. The Macro will then read this information, insert the new row and fill in the specified cells. I'm very new to VBA (but have done VB waaaaaaaaaaaay back when). Any help would be greatly appreciated. I've only successfully gotten it to insert a row after searching for a value but not for a row #. Later I'm hoping to get the insertion macro to work on other specified sheets w/ the same exact layout and # of rows. Thank you again for any help or advice. -jas |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Inserting information from a database with a macro | Excel Discussion (Misc queries) | |||
Need help with filtering & inserting information :( | Excel Worksheet Functions | |||
Inserting information from One Sheet to Many | Excel Worksheet Functions | |||
Inserting information into a unmade row with a macro | Excel Discussion (Misc queries) | |||
INSERTING INFORMATION IN A CELL | Excel Discussion (Misc queries) |