PC Review


Reply
Thread Tools Rate Thread

command button on form to open sheets

 
 
=?Utf-8?B?Z2JwZw==?=
Guest
Posts: n/a
 
      25th Sep 2007
Can I simply use a hyperlink to open a sheet from a command button on a form?
I don't see how to do this? Is there any code out there to do this?
 
Reply With Quote
 
 
 
 
JW
Guest
Posts: n/a
 
      25th Sep 2007
Talking about a UserForm in VBA or a form that you just created in a
worksheet? By Sheet do you mean a worksheet within the current
workbook, or do you meen a separate workbook?
If a UserFrom:
Sheets("ThisSheet").Activate will activate the sheet called
"ThisSheet"
Workbooks.Open "C:\ThisWorkbook.xls" will open the workbook in the C:\
dirve called "ThisWorkbook".

If you are referring to a form on a worksheet, then the same code can
be applied. Just right click on the command button in your shet and
select Assign Macro.
gbpg wrote:
> Can I simply use a hyperlink to open a sheet from a command button on a form?
> I don't see how to do this? Is there any code out there to do this?


 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
command button for open sheets =?Utf-8?B?Z2JwZw==?= Microsoft Excel Programming 0 27th Aug 2007 03:34 PM
Command Button>Form Operation> Open Form...also need find function =?Utf-8?B?YTQyMHA=?= Microsoft Access 1 5th Aug 2007 05:35 AM
Form/Subform/Command Button to Open Form - Type Mismatch Error =?Utf-8?B?U2hhcm9u?= Microsoft Access Form Coding 2 12th Jul 2007 10:02 PM
save current form and open another form using a single command button? moe leaer via AccessMonster.com Microsoft Access Forms 3 26th May 2005 04:44 PM
Problem adding a command button to a form in order to open another form =?Utf-8?B?SmFuaWNl?= Microsoft Access Getting Started 2 10th May 2004 11:31 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 04:46 PM.