VBA Help (Excel)

[ramirez]

Hi Guys need a hand!

I need to have a procedure so that if a particular cell does NOT have any data in it, an error message is presented.

Only complication is that at the same time, if in a checkbox a "NA" is selected, this error message mustn't be presented.

Can anyone give me a heads up ?

it's been a while since I did VB, i'm sure its pretty simple. Is there a command like Len(CellName) > 0 or something?

 

[blastman]

I only know vbs but can't you just have an if statement within an if statment??

if (radiobutton.ticked = true) then

       if (objExcel.cells(1,2).value = "") then
             msgbox "Error Message"
       end if

end if

Please excuse my lack of radio button knowage, but I hope it gives an idea of the path you should be looking down

Hope it helps