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

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

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

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

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