Register a SA Forums Account here!
JOINING THE SA FORUMS WILL REMOVE THIS BIG AD, THE ANNOYING UNDERLINED ADS, AND STUPID INTERSTITIAL ADS!!!

You can: log in, read the tech support FAQ, or request your lost password. This dumb message (and those ads) will appear on every screen until you register! Get rid of this crap by registering your own SA Forums Account and joining roughly 150,000 Goons, for the one-time price of $9.95! We charge money because it costs us money per month for bills, and since we don't believe in showing ads to our users, we try to make the money back through forum registrations.
 
  • Post
  • Reply
Dr.Magnificent
Dec 24, 2007

Comes with hands on care.
Fun Shoe
When I was first learning, I found these videos pretty helpful. http://www.youtube.com/user/ExcelIsFun#p/c/D8EEA7196D943ED5/0/Wq7p4uoj4Vo

He has other playlists full of even more videos. There is even a playlist devoted to him and another excelblogger solving various problems with macros or formulas, so it exposes you to other ways to do things.

Adbot
ADBOT LOVES YOU

Dr.Magnificent
Dec 24, 2007

Comes with hands on care.
Fun Shoe
For checking on entry, if you don't have a ludicrous number of entries, I just use Application.WorksheetFunction.countif and have an if statement check if it is greater than 0, add to set or return a message box as needed.

  • 1
  • 2
  • 3
  • 4
  • 5
  • Post
  • Reply