Use of Dialog

[markuss]

Hi all, I'm curious about use of excel dialog. What is for? and how to use it and what other benefits or advantages in using for common financial worksheet?
Thank you.

[JLatham]

Dialogs can make things easier for you and your end user. They can be used
to pre-validate entered information, apply business rules to it before
placing it onto a worksheet, and provide a way of making sure that all needed
information is entered for a given situation.

Lets say you use an Excel workbook to handle weekly payroll. You may need
to define an employee in a particular way, with some basic information:
Name, SSAN, Job Title, Pay Rate, etc.

You could put a button (or I like to use Text Boxes from the Drawing
toolbar) on the sheet that when clicked on would open up the dialog to enter
information about a new employee. Once the user enters the information and
clicks a "do it" button on that dialog form, you could then use VBA code to
check the information and validate it and place it properly on the worksheet.

I actually have something like this in use, and because the information on
the worksheets is so critical, all data entry and editing on all of the
worksheets in the workbook is done through dialogs that are provided from
pull-down choice of operations lists on the sheets.

In previous versions people would come along and enter numbers overwriting
formulas, enter invalid information for things like employee ID number, etc.
The use of dialogs has done away with those problems.

"markuss" wrote:

>
> Hi all, I'm curious about use of excel dialog. What is for? and how to
> use it and what other benefits or advantages in using for common
> financial worksheet?
> Thank you.
>
>
> --
> markuss
> ------------------------------------------------------------------------
> markuss's Profile: http://www.excelforum.com/member.php...o&userid=34966
> View this thread: http://www.excelforum.com/showthread...hreadid=553085
>
>

[markuss]

Thank you for that Jlatham.
I will start using dialogs in my next excel project for inventory management. I hope it will be effective and working. But I have question regarding file size, is there a material effect in file size if I've added several dialogs to my workbook or is there a way we can compress the file size?

[JLatham]

Naturally there's a price to pay. I took an empty 3-sheet workbook and saved
it to disk: 14KB. Added one user form with a text entry box and a label to
it along with a line of code in the workbook's _Open event to display the
user form. That took 14KB of disk space.

I have a workbook that is used to track invoice costs on a contract, it has
8 worksheets, 2 of which use between 300-400 rows and 15 columns of
information on them, there are 3 code modules and 13 user forms. Disk drive
space required is just over 900KB.

"markuss" wrote:

>
> Thank you for that Jlatham.
> I will start using dialogs in my next excel project for inventory
> management. I hope it will be effective and working. But I have
> question regarding file size, is there a material effect in file size
> if I've added several dialogs to my workbook or is there a way we can
> compress the file size?
>
>
> --
> markuss
> ------------------------------------------------------------------------
> markuss's Profile: http://www.excelforum.com/member.php...o&userid=34966
> View this thread: http://www.excelforum.com/showthread...hreadid=553085
>
>

[JLatham]

Oops - typo: 3 sheets only = 14KB disk file. 3 Sheets + extras = 24KB of
disk space.

"markuss" wrote:

>
> Thank you for that Jlatham.
> I will start using dialogs in my next excel project for inventory
> management. I hope it will be effective and working. But I have
> question regarding file size, is there a material effect in file size
> if I've added several dialogs to my workbook or is there a way we can
> compress the file size?
>
>
> --
> markuss
> ------------------------------------------------------------------------
> markuss's Profile: http://www.excelforum.com/member.php...o&userid=34966
> View this thread: http://www.excelforum.com/showthread...hreadid=553085
>
>