Dear Friends,
I have a simple MSGBOX code requirement. In this if the range (No_Data_Range) has a value “add” then user should get the message “ Sorry No Data Allowed”.
I am getting error object variable or with block variable no set. Also this message should be displayed automatically as "Add" value is displayed in range.
Please Login or Register to view this content.
Thanks,
Nisha
Sub test()
Dim No_Data_Range As Range
If No_Data_Range.Value = "Add" Then
MsgBox "Sorry No Data Allowed"
End If
End Sub
Please ensure you mark your thread as Solved once it is. Click here to see how.
If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.
You've declared No_Data_Range but you haven't set it to reference anything, so it will be Nothing.
If posting code please use code tags, see here.
Hi Mike.. still getting the same error i.e. object variable or with block variable no set
Nisha
Hi Norie.. can you please give me the correct code.
Nisha
Is No_Data_Range a named range?
Is it only one cell?
Noire... No_Data_Range is a range e.g. B:B10
Thanks,
Nisha
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks