Pop-Up

[sdc1234]

does anyone know how I can make a pop up appear "are you sure" after information is entered

 

[Akashwani]

Hi,

You could try data validation.
What type of data will the cell hold?
You can set data validation for the cell and set an Input Message when the cell is selected and an Error message if the wrong data is entered.

A vba solution would be something like this...

Private Sub Worksheet_Change(ByVal Target As Range)
    If Target.Column = 4 Then
        
        MsgBox "Are you sure?", vbInformation, "sdc1234 says......"
        
    End If
End Sub

Right click the sheet tab, click view code and paste this code into the white area. Column = 4 means column D change the number to suit your column.

Good Luck

Ak

 

[sdc1234]

thank you


1 more ? I am trying to put a button on the page that says click here, what I want it to do is to enable macros on that specific computer, is this possible

 

[Akashwani]

Hi,

I use a shape as a button then assign the relevant macro to the shape. In 2007, click Insert, Shapes, then select the shape that you wish to use.

I'm not sure how you would go about enabling macros pre 2007, I guess it would be under Tools, Macros, Protection or something like that. In 2007 you can save your file as XLSM, as standard practice I always save as 97-2003 compatible, just in case it ends up with a user who is on pre 2007.

Good luck.

Ak