thomas.szwed
04-18-2008, 03:12 AM
Hi,
Please take a look at my userform, by clicking on the pencil icon. If you enter a number into the bottom right text box on the form it skips to where this row is located on the spreadsheet. But there are two problems.
a) If you enter 0 by mistake - Runtime Error
b) if you enter 1 > it picks up my column headings. And because of validation on the user form it brings up an error message (because text has been entered where numbers should be). This is annoying as if you want to find row number 100 you have to enter 1 first, therefore you always see this warning message.
Would there not be a way around this by pressing return after entering a number in this textbox, instead of it automatically skipping to the row as you type the numbers in???
Any help is much appreciated. Thanks
password = pastille
Please take a look at my userform, by clicking on the pencil icon. If you enter a number into the bottom right text box on the form it skips to where this row is located on the spreadsheet. But there are two problems.
a) If you enter 0 by mistake - Runtime Error
b) if you enter 1 > it picks up my column headings. And because of validation on the user form it brings up an error message (because text has been entered where numbers should be). This is annoying as if you want to find row number 100 you have to enter 1 first, therefore you always see this warning message.
Would there not be a way around this by pressing return after entering a number in this textbox, instead of it automatically skipping to the row as you type the numbers in???
Any help is much appreciated. Thanks
password = pastille