Making forms relative to worksheets?
Making forms relative to worksheets?
Making forms relative to worksheets?
Making forms relative to worksheets?
Making forms relative to worksheets?
Making forms relative to worksheets? Making forms relative to worksheets? Making forms relative to worksheets? Making forms relative to worksheets? Making forms relative to worksheets? Making forms relative to worksheets? Making forms relative to worksheets? Making forms relative to worksheets?
Making forms relative to worksheets? Making forms relative to worksheets?
Making forms relative to worksheets?
Go Back  Xtreme Visual Basic Talk > > > > Making forms relative to worksheets?


Reply
 
Thread Tools Display Modes
  #1  
Old 04-14-2002, 09:05 AM
rimpet
Guest
 
Posts: n/a
Default Making forms relative to worksheets?


This might be more of an Excel based question rather than VB. I have two worksheets in a spreadsheet, each with a form for entering data into that sheet. How can i it so that the forms only open when the correct worksheet is open?

Any help would be fantasticola!

rimpet
Reply With Quote
  #2  
Old 04-14-2002, 03:54 PM
Michael_IMaking forms relative to worksheets? Michael_I is offline
Contributor

* Expert *
 
Join Date: Dec 2001
Posts: 725
Default

Hey,

Here is something that I put together really quickly so don't use the code but rather the concept involved.

Private Sub Workbook_SheetActivate(ByVal Sh As Object)
If ActiveSheet.Name = "Sheet1" Then
UserForm1.Show
Else
If ActiveSheet.Name = "Sheet2" Then
UserForm2.Show
End If
End If
End Sub


Everytime a worksheet is activated, it will search through this code.

Mike
Reply With Quote
  #3  
Old 04-14-2002, 04:50 PM
rimpet
Guest
 
Posts: n/a
Default

Cheers, v. useful.

rimpet
Reply With Quote
  #4  
Old 04-14-2002, 06:48 PM
Timbo's Avatar
TimboMaking forms relative to worksheets? Timbo is offline
Green-Eyed

Super Moderator
* Guru *
 
Join Date: May 2001
Location: Bangkok, Thailand
Posts: 10,261
Default

Or name each form according to the index of the worksheet it is to be used for (ie. "frm1" for Sheet1) then use this code:
Code:
Sub OpenSheetForm()
    UserForms.Add("frm" & ActiveSheet.Index).Show
End Sub
__________________
"He's not the Messiah. He's a very naughty boy!" - Brian's mum

Can't find the answer? >> Try something new!
Become a Professional
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

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 Off
HTML code is Off

Forum Jump

Advertisement:





Free Publications
The ASP.NET 2.0 Anthology
101 Essential Tips, Tricks & Hacks - Free 156 Page Preview. Learn the most practical features and best approaches for ASP.NET.
subscribe
Programmers Heaven C# School Book -Free 338 Page eBook
The Programmers Heaven C# School book covers the .NET framework and the C# language.
subscribe
Build Your Own ASP.NET 3.5 Web Site Using C# & VB, 3rd Edition - Free 219 Page Preview!
This comprehensive step-by-step guide will help get your database-driven ASP.NET web site up and running in no time..
subscribe
Making forms relative to worksheets?
Making forms relative to worksheets?
Making forms relative to worksheets? Making forms relative to worksheets?
Making forms relative to worksheets?
Making forms relative to worksheets?
Making forms relative to worksheets? Making forms relative to worksheets? Making forms relative to worksheets? Making forms relative to worksheets? Making forms relative to worksheets? Making forms relative to worksheets? Making forms relative to worksheets?
Making forms relative to worksheets?
Making forms relative to worksheets?
 
Making forms relative to worksheets?
Making forms relative to worksheets?
 
-->