Beginning Microsoft Excel VBA Programming for Accountants by Derek Harlan

Author:Derek Harlan
Language: eng
Format: epub
Tags: Excel, VBA, Accountant, Accounting, Programming, Beginning Programming
Publisher: Derek Harlan
Published: 2017-12-01T00:00:00+00:00

Now when you change the options you’ll see the cell link update with the number of the options draw order. One other note – you only need to set the Cell Link for one item in the Group Box the other Option Buttons will automatically update with that Cell Link, again since the choice has to be mutually exclusive there only needs to be one cell link. In our VBA code we can look up the value in the Cell Link and have Excel make a decision – for example a Select Case type of decision where the program takes different options based on the choice that was selected.

For a clean design you may want to put the cell link far off of screen - for example a cell like ZA1 – this will keep the user from having to see this and keep some of the magic of your application hidden. At the end of this chapter there is a comprehensive example in which we’ll create a journal entry using these techniques.

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.