Message box from data validation disappeared

Stevenn

Active Member
Joined
Feb 8, 2012
Messages
259
I've used data validation and have added a message, but I've somehow removed the message box which should appear when a cell with a message is selected. How can I make it return? :biggrin:
 

Some videos you may like

Excel Facts

Easy bullets in Excel
If you have a numeric keypad, press Alt+7 on numeric keypad to type a bullet in Excel.

Trevor G

Well-known Member
Joined
Jul 17, 2008
Messages
6,478
Suggestion. Press F5 (Goto) then select Special bottom left button, then bottom right select Data Validation then click OK. From there use the Data Validation and you should be able to reset your message and rules.
 

puru.sve

Active Member
Joined
Apr 29, 2010
Messages
292
Hi , Just select your validation cell and open validation window from data validation menu and set your message


Click on data validation ---> then select input message -- > then put your title and input message both.

If you only put title then it will not appear, you have too fill input message as well
 

Stevenn

Active Member
Joined
Feb 8, 2012
Messages
259
I've filled both title and text. It was viewable before I replaced the location of the message box. I don't know where I placed it. I have a lot of validated cells. Isn't it possible to recall the old location - maybe with VBA?
 

puru.sve

Active Member
Joined
Apr 29, 2010
Messages
292
Hi Stev

You can find out, if you know the validation range address .


Sub findDataValidation()
Dim strFind As String

For Each Rng In ActiveSheet.usedrange

On Error Resume Next
strFind = Rng.Validation.Formula1
If strFind = "=$G$10:$G$14" Then ' set here validation address
MsgBox Rng.Address
Exit Sub
End If

Next Rng

End Sub
 
Last edited:

Stevenn

Active Member
Joined
Feb 8, 2012
Messages
259
My sheet contains very different validation rules. I've no problems finding out which cells to which I've added validation rules, but I've just placed the message box somewhere in the sheet and I can't find it :(
 

Watch MrExcel Video

Forum statistics

Threads
1,099,164
Messages
5,467,006
Members
406,516
Latest member
richcresswell

This Week's Hot Topics

Top