Hi,
I have the following code that, when I run it, it flashes through a sheet for a few seconds then finishes. It is accomplishing what I want (i.e. the textbox values are populating the "Info" sheet) but I know something that I have there is not functioning properly.
Can anyone help?
Please Login or Register to view this content.
What exactly is not functioning properly. I would recommend coding with Option Explicit it helps to avoid errors by forcing you to declare your variables correctly rather than relying on excel to guess what you mean.
If your questions has been answered to your satisfaction please don't forget to do the following:
Add Reputation ... and ... Mark Thread as Solved
Thanks,
Ma 10:8b Freely you have received; freely give.
It is causing the screen to flash for several seconds before processing the request.
I think I resolved it. I removed the command to show Sheet1, and it sped things up
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks