get an error if i press calculate-1 button without entries in the 4 Labels in Red

[jeff]

Hello bakerman

yes a bad miss by me

what advice would you give for learning VBA...do you recommend any books?

Cheers

Jeff

[bakerman]

There maybe dozens of books on the market so saying this one or that one is rather difficult.
The macro-recorder is a good place to start. Just record all the steps you take and look what code comes out.
Then you can start by shortening that code by eliminating Select, Selection, Activate because in 99% of the cases it's unnecessary.
A lot of trial and error and visiting forums to view codes and learning from that also helps a lot.