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

A Macro to create a grid

0

I am trying a project to use Excel macro(s) to create a 9x9 grid of boxes.  In each box, I will have a letter ('A', 'B', etc.)  then a couple of blank lines, then a randomly genterated set of four characters (for example g%6H).  Each time I press F9, a new set of random characters get made.  I am stuck on, how do I use macros to "draw" my grid, that I then populate with the letter, spaces, and random characters in each cell of the grid.  Any ideas how I start with making a grid?

Answer
Discuss

Answers

0

The best way forward is to use the Macro Recorder to record your key strokes as you create the grid manually. That will give you code from which you can start developing the code you will actually use. It will also give you a visual of the desired result which you can use to explain your ideas to those you might ask for help.

Discuss


Answer the Question

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