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.
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?
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
sorry for not being clear to u.. 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
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
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.