If This AND That Then...Else... in VBA

A

Amber_D_Laws

Ok, I want to write an if statement (although a Case Select would wor
too) that will test for condition1 AND condition2. Is this eve
possible?

Any help or sage wisdom on the subject is welcome.
Thanks,
Ambe

--
Amber_D_Law

I am currently working for Severn Trent Laboratories as a Projec
Manager's Assistant, and have through helping update lots of ou
operational procedures recently begun learing VB
 
D

davesexcel

if selection.value>10 then
if selection.value=12 then
'your code here'
end if
end i
 
A

Amber_D_Laws

It never ceases to amaze me how complicated I can make something that in
truth is incredibly simple.

Thanks guys!
I appreciate you taking me back to reality and reminding me that VBA
really is just that logical. :)

Take care,


--
Amber_D_Laws

I am currently working for Severn Trent Laboratories as a Project
Manager's Assistant, and have through helping update lots of our
operational procedures recently begun learing VBA
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top