N
Neil Pearce
Good afternoon all,
A building's ground floor plan is created visually by a user in Excel by
highlighting cells and filling them with the colour red. Each cell on the
workbook is equivalent to 1m2. The building must fit into a 50x50 plot area
B2:AY51.
I now need to enable the user to input different floor finishes within this
footprint. Therefore I wish to place an outline border of the drawn shape
into a new workbook so that the user can fill the shape with different colour
fills (each representing a different floor finsih, e.g. carpet, vinyl etc.)
Is there a way of creating a code to do this that can then be attached to a
button?
Many thanks,
Neil
A building's ground floor plan is created visually by a user in Excel by
highlighting cells and filling them with the colour red. Each cell on the
workbook is equivalent to 1m2. The building must fit into a 50x50 plot area
B2:AY51.
I now need to enable the user to input different floor finishes within this
footprint. Therefore I wish to place an outline border of the drawn shape
into a new workbook so that the user can fill the shape with different colour
fills (each representing a different floor finsih, e.g. carpet, vinyl etc.)
Is there a way of creating a code to do this that can then be attached to a
button?
Many thanks,
Neil