Re: command button on form to open sheets
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
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.
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?
- RE: Need a Macro
... Dim lngPgRef As Long ... The above line uses the VBA string variable in lieu of an actual string. ... Don’t confuse VBA variables with named ranges on a worksheet. ... Rows.Count is a variable that hold the total number of rows on the sheet ...
- Re: Hello, is this message visible?
... This is only one workbook titled March 2008. ... Master to a new worksheet with a new name, I need the new worksheet to add ... Names, sheet names, cells, etc... ...
- Re: excel process problem 2
... Thisworkbook and paste in to a text file. ... Start a new workbook, go to VBE. ... > 3) any vba example of password box when open the workbook and the ... > Below code gets a valid sheet no. from the user and transfers contents ...
- Re: Data Validation
... Since it's working now, with the new version of the worksheet, I'd make a few backup copies! ... What I have is is a time sheet workbook for as many employees as one would like to track. ... This is where the data validation is, to select the shift, then with a countif formula I get the totals for each. ...
- Re: How do I code a "self-destruct" triggered after a certain date?
... enable macros when the workbook is opened then the code will not kick in. ... a blank sheet and deletes all the other sheets. ... Private Sub Workbook_Open ... Dim m As Date, ws As Worksheet ...