Macros

[priya_anthony]

Hi experts Really need your help

What the requirement is when a cell is active in a particular column
and the user presses the Shift and F4 to gether then a user form should be displayed

Eg: if the column name is students then if a cell is active from that column and the user presses the Shift and F4 together then a form for students should be displayed
this applies to the other columns too
Please help..........

priya

 

[Stormseed]

In the first place, a user form should be created. Have you done that?

 

[priya_anthony]

macros

In the first place, a user form should be created. Have you done that?

Yes the user form is created needs to display that form on to the excel sheet when Shift and F4 is pressed
that is where i have stucked up

So kindly help

 

[zzjasonzz]

right click on sheet tab double click on ThisWorkbook on the far left under microsoft excel objects then paste:

Private Sub Workbook_Open()
Application.OnKey "+{F4}", "yourmacro"
End Sub

then rightclick on thisworkbook and Insert > Module then put this in it

Sub yourmacro()
If Selection.Column = 1 Then
    userformname.Show
End If
End Sub

do all the error checking (like making sure it is the right column, right sheet etc) in yourmacro

you should be able to work it out from that

 

[priya_anthony]

Thank you very much for your help i have just tried a dummy of it it really works
just need to integrate on to the project

Once again thank you very much for your help