message box

**Anil Juyal** · 11-21-2012, 05:00 AM

I have a sheet
if i enter 1 in column a cell then show a message box
if i enter 2 in column a cell then show a message box
if i enter 3 in column a cell then show a message box
if i enter 4 in column a cell then show a message box

please help me I spent my one weak for the same

**Kyle123** · 11-21-2012, 05:19 AM

Private Sub Worksheet_Change(ByVal Target As Range)
    If Not Intersect(Target, Columns(1)) Is Nothing Then
        If Target.Value >= 1 And Target.Value <= 4 Then
            MsgBox "Something"
        End If
    End If
End Sub

Worksheet event code is stored on a worksheet module. To add it to your worksheet, do the following:

Copy the code
Select the worksheet in which you the code to run
Right click on the sheet tab and choose View Code, to open the Visual Basic Editor.
Where the cursor is flashing, choose Edit | Paste

**Anil Juyal** · 11-22-2012, 05:05 AM

many many thanks
you save my one month

thks again

**derato** · 04-15-2013, 05:55 PM

Hi Kyle,
based on this information how do I get the vba to select a workbook instead of the worksheet. Thanks

**RHCPgergo** · 11-21-2012, 05:26 AM

Hi,

can you be more specific? I can only offer vague advice with your description.

You should use the worksheet_change event and the MsgBox function. Something like this:

Private Sub Worksheet_Change(ByVal Target As Range)

If Target.Column = 1 Then ' <-- this is the column you check
    If Target = "1" Then MsgBox "You entered 1."
    If Target = "2" Then MsgBox "You entered 2."
    If Target = "3" Then MsgBox "You entered 3."
    If Target = "4" Then MsgBox "You entered 4."
End If

End Sub

You need to write the code in the worksheet's code window. Change it the way you like.

**Anil Juyal** · 11-23-2012, 09:25 AM

hi how r u??
maye we use any vba code like vlookup

thanks in advance

**Anil Juyal** · 01-19-2013, 02:54 AM

many-many thnks

please help me also about:
i have 2 sheet s
sheet 1
col a col b
code qty
k 4
m 6
b 8
m 5
k 3
m 1

Sheet 2
col a col b
code qty
k
m
b

i used vlookup in sheet 2 it takes first value in col b, but i want last value, pls help me

**Anil Juyal** · 04-08-2013, 11:00 AM

hi frds
please help me
if i enter 1 in column a cell then higlighted row in red color (A:R)
if i enter 2 in column a cell then higlighted row in Yellow color (A:R)
if i enter 3 in column a cell then higlighted row in Green color (A:R)
if i enter 4 in column a cell then higlighted row in Orange color (A:R)

**arlu1201** · 04-16-2013, 02:13 AM

derato,

Unfortunately you need to post your question in a new thread, it's against the forum rules to post a question in the thread of another user. If you create your own thread, any advice will be tailored to your situation so you should include a description of what you've done and are trying to do. Also, if you feel that this thread is particularly relevant to what you are trying to do, you can surely include a link to it in your new thread.