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:
 

Excel Facts

Pivot Table Drill Down
Double-click any number in a pivot table to create a new report showing all detail rows that make up that number

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
 

Forum statistics

Threads
1,141,025
Messages
5,703,812
Members
421,318
Latest member
cg_cartoonexcel

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top