Forum Discussion
Excel VBA Object Populate Cell
Hi! I have a bunch of objects for a visual representation that I can select and mark certain colors using macros. I just wanted to see if I mark a certain object can I have it auto populate a cell wi...
Which cell would you like to populate with what?
It would be AM3, which is a dropdown list, so if it was "Fabric" there's an option to select F.
You'll have to explain in MUCH more specific detail what you want to do.
- If you reference the image I posted. Those little objects are referencing a visual representation of conduits underground 1-84. I click on conduit 1 and can mark it by pressing ctrl+w to highlight it the color using VBA. I just wanted to know if I click object "1" I can have it update AM3 based whatever key I press. Really hard to explain without almost doing a video demo.
How do I know which shape is related to which cell?