PLEASE HELP...THANK YOU!!!

popopo

New Member
Joined
Oct 16, 2006
Messages
4
dear people...

I would really appreciate if anyone knows how to use the hyperlink menu so that i could link it to the data entry form that is already created when we click to the Data>Form menu.

Thank you for your help!! :biggrin:
 

Some videos you may like

Excel Facts

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.

agihcam

Well-known Member
Joined
Jan 16, 2006
Messages
1,624
Hi -
Welcome to the board.
If I understand you correctly, your main problem is how to activate Form from Data menu isn't it? but why you want a hyperlink to trigger this event?
 

popopo

New Member
Joined
Oct 16, 2006
Messages
4
hello

i want to link it so that i can create some sort of simple menu. for example, data input button. if user click this button, it will directly open the automated generate form in the microsoft excel 2003 that can be found under the data>form menu. thanx 4 da reply anyway :LOL:
 

agihcam

Well-known Member
Joined
Jan 16, 2006
Messages
1,624
activesheet.showdataform
Code:
Application.DisplayAlerts = False
ActiveSheet.ShowDataForm
Application.DisplayAlerts = False
put that code in your button and try.
 

popopo

New Member
Joined
Oct 16, 2006
Messages
4

ADVERTISEMENT

hmmm

sorry for not being clear to u.. :biggrin: i mean a cell link button...not a normal push button...for example cell c12 contain words(input data), then by clicking the hyperlink, it goes directly to the activesheeform..thanks a lottttttt :LOL:
 

agihcam

Well-known Member
Joined
Jan 16, 2006
Messages
1,624
ok. from your sheet where c12 has a hyperlink, right click on the sheet tab > view code then paste this code. close the VBE then click on hyperlink c12.
Code:
Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink)
Application.DisplayAlerts = False
ActiveSheet.ShowDataForm
Application.DisplayAlerts = False
End Sub
 

popopo

New Member
Joined
Oct 16, 2006
Messages
4
yeah !!

u're the man !! what bout print?? same concept as the input data...for c15, when clicked, will view the print windows from the file>print
 

agihcam

Well-known Member
Joined
Jan 16, 2006
Messages
1,624
same concept also.
Code:
Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink)
Sheets(2).PrintPreview 'or
sheets(2).printout
End Sub
 

Watch MrExcel Video

Forum statistics

Threads
1,113,992
Messages
5,545,373
Members
410,679
Latest member
rolandbianco
Top