Solved

VBA Explanation of syntax Update.Show

Posted on 2014-01-19
4
187 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 500 total points
ID: 39791901
I believe it displays the form named "Update" to the user.
0
 
LVL 11

Assisted Solution

by:Angelp1ay
Angelp1ay earned 500 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

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

How to quickly and accurately populate Word documents with Excel data, charts and images (including Automated Bookmark generation) David Miller (dlmille) Synopsis In this article you’ll learn how to use ExcelToWord! to copy data,charts, shapes …
This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

760 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

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now