PDA

View Full Version : How can I use Zoom or Pan Command in VBA?


vndesperados
15-05-2005, 08:04 AM
Hi!
I've a form with some Button on this form. I wana a Button like a Zoom command. This's mean, when I click on this Button, the form is hiding and I can use Zoom or Pan, then I press ESC, the form is show
Can you help me?
Any fedback is helpful

Eddie
15-05-2005, 08:38 PM
8) Try something like this ...

Private Sub CommandButton1_Click()
Me.Hide
ZoomPickWindow
Me.Show
End Sub

Gms
23-07-2007, 01:18 PM
Create a button cmdModal an try this code

Private Sub CmdModal_Click()
If CmdModal.Caption = "Modeless" Then
CmdModal.Caption = "Modal"
Me.Hide
Me.Show vbModless
ElseIf CmdModal.Caption = "Modal" Then
CmdModal.Caption = "Modeless"
Me.Hide
Me.Show vbModal
End If
End Sub