Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

VBA Explanation of syntax Update.Show

Posted on 2014-01-19
4
Medium Priority
?
243 Views
Last Modified: 2014-01-19
Hi again,

I asked a similar question before and realised that I still don't understand!

Here goes;

Sub Start_Click()
Update.DTTo.Value = Date - 1
Update.DTFrom.Value = Date - 1
Update.DTFrom.Day = 1
Update.Show

End Sub


Specifically, what does "UPDATE.SHOW" mean?
0
Comment
Question by:Patrick O'Dea
  • 3
4 Comments
 
LVL 11

Accepted Solution

by:
Angelp1ay earned 2000 total points
ID: 39791901
I believe it displays the form named "Update" to the user.
0
 
LVL 11

Assisted Solution

by:Angelp1ay
Angelp1ay earned 2000 total points
ID: 39791902
See the section "Displaying a Userform" at this link:
http://www.excel-spreadsheet.com/vba/userforms.htm

Displaying a Userform

Once the userform has been created, the next stage is to test to see how the user form will look. You can use the Run (F5 function key in design time mode) command when the active form is displayed.  But, writing code is ultimately how a user form will be used.

Decide where the code is to be stored (in a Module, Worksheet or Workbook).

Use the name of the form with the Show method command.

Example:
Sub DisplayMyUserform()
    MyUserForm.Show
End Sub


The user form is known, as ‘MyUserForm’ and the Show method will display the user form.

There is one optional argument called Modal which can be explicitly defined and has a value of 0  or 1 .
 
1 = a modal state which means that users have to complete the form and can not click anywhere else (in the background).
 
0 = a modeless state which allows users to click outside the form area.
 
The default is 1  if omitted.
 
MyUserForm.Show 0
MyUserForm.Show 1 or MyUserForm.Show
0
 

Author Closing Comment

by:Patrick O'Dea
ID: 39792114
Ah ! got it now!

The confusion arose because the author of the sheet called the form "Update"...

I had assumed that the "Update" was some served word in VBA etc.
0
 
LVL 11

Expert Comment

by:Angelp1ay
ID: 39792134
So did I at first look! It's the previous lines that give it away.
Glad to help :) Have a great day!
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
Windows Explorer lets you open cabinet (cab) files like any other folder. In VBA you can easily handle normal files and folders, but opening and indeed creating cabinet files takes a lot more - and that's you'll find here.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

571 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question