Thread: message box in an excel cell
View Single Post
  #3 (permalink)  
Old 10-14-2007, 06:46 PM
BurgoEng BurgoEng is offline
Junior Member
  
Join Date: Oct 2007
Posts: 28
iTrader: (0)
BurgoEng is on a distinguished road
Wink
Hi,
Try this code.

sub worksheet_open

if application.activesheet.cells(5,2) ="" then
application.activesheet.cells(5,2).select
msgbox ("Please enter value in B5")
end if
end sub

Cheers!
Reply With Quote