Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Magnifying one cell at a time for assisted reading

0

The task was to write a program to make the letters in a single cell very large and display it with maximum contrast for use by people with impaired vision. I wrote such a program and wish to share it here in my own answer below. Comments and suggestions for improvement are welcome, as are alternative answers submitting programs written for the same purpose.

Answer
Discuss

Answers

0

The program demonstrated in the attached workbook allows the user to adjust the desired viewing size up to a multiple of 8 time the original size (more, if one amends the code). Colours for contrast, set to black on white by default, can be modifiedĀ in a location in the code especially prepared for that purpose.

The user can move around a sheet using either key strokes or mouse clicks. There is an F2 key which allows editing of a cell's formula in the enlargement.

The workbook contains a working demonstration as well as a dedicated Help tab that contains detailed instructions for installation, setup (very simple), modification (also easy) and use.

Discuss


Answer the Question

You must create an account to use the forum. Create an Account or Login