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

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.
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?
 
Upvote 0
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:
 
Upvote 0
activesheet.showdataform
Code:
Application.DisplayAlerts = False
ActiveSheet.ShowDataForm
Application.DisplayAlerts = False
put that code in your button and try.
 
Upvote 0
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:
 
Upvote 0
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
 
Upvote 0
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
 
Upvote 0
same concept also.
Code:
Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink)
Sheets(2).PrintPreview 'or
sheets(2).printout
End Sub
 
Upvote 0

Forum statistics

Threads
1,213,543
Messages
6,114,238
Members
448,555
Latest member
RobertJones1986

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
Back
Top