Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Keep getting Errors in Code
Hello, I currently have some VBA code, that when a button is pressed,
it prompts an InputBox that requires the user to enter their center number. According to thier center number, after enter is pressed, a new workbook is created containing three copied sheets from other workbooks. For some reason I keep getting an error whenever I am testing any center number beyond the 1st one in the sub routine...I'm not sure how to solve this...I've tried to do If...ElseIf...Then but that didn't seem to work either... any help would be greatly appreciated, thanks! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Keep getting Errors in Code
post the code that gives the problem
" wrote: Hello, I currently have some VBA code, that when a button is pressed, it prompts an InputBox that requires the user to enter their center number. According to thier center number, after enter is pressed, a new workbook is created containing three copied sheets from other workbooks. For some reason I keep getting an error whenever I am testing any center number beyond the 1st one in the sub routine...I'm not sure how to solve this...I've tried to do If...ElseIf...Then but that didn't seem to work either... any help would be greatly appreciated, thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ERRORS IN CODE 2003 | Excel Discussion (Misc queries) | |||
Same code - errors on different machine? | Excel Programming | |||
Errors in VB Code since adding macro | Excel Discussion (Misc queries) | |||
VBA Code Errors | Excel Discussion (Misc queries) | |||
Calling a bit of code from a sheet errors | Excel Discussion (Misc queries) |