Excel VBA Object Populate Cell

Question

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 with certain data.&nbsp;Sub Fabric()
'
' Fabric Macro
'
' Keyboard Shortcut: Ctrl+w
'
    With Selection.ShapeRange.Fill
        .Visible = msoTrue
        .ForeColor.RGB = RGB(0, 32, 96)
        .Transparency = 0.5
        .Solid
    End With
    With Selection.ShapeRange.Fill
        .Visible = msoTrue
        .ForeColor.RGB = RGB(0, 32, 96)
        .Transparency = 0.5
        .Solid
    End With
End Sub&nbsp;&nbsp;

hansvogelaar · Answer

itsmatta&nbsp;
Which cell would you like to populate with what?

itsmatta · Answer

HansVogelaar&nbsp;It would be AM3, which is a dropdown list, so if it was "Fabric" there's an option to select F.&nbsp;

hansvogelaar · Answer

itsmatta&nbsp;
You'll have to explain in MUCH more specific detail what you want to do.

itsmatta · Answer

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.

hansvogelaar · Answer

itsmatta&nbsp;
How do I know which shape is related to which cell?

Forum Discussion

Excel VBA Object Populate Cell

Share

Resources