Display of Drawing/Shapes Object on to List Box or any other Control

Vijay Anand

Board Regular
Joined
Jan 21, 2008
Messages
69
Hi,

I have some Drawing objects ( circles,lines with some text ) embeded into some series of Excel worksheet cells which is Back-end file.

I had developed a Front-end GUI which pops a List box which list out all the contents of the cells in the Back-end file.

Can any one suggest me as how to bring or reflect these drawing objects on the listbox or for that matter any other VBA controls.

Your help will be much appreciated.

Thanks & Regards,

Vijay Anand.R:)
<!-- / message -->
 

Some videos you may like

Excel Facts

Excel Can Read to You
Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.

NdNoviceHlp

Well-known Member
Joined
Nov 9, 2002
Messages
2,723
Not sure if I fully understand your needs. Here's a guess. HTH. Dave
Code:
Sub ListboxShapes()
Dim shp As Shape
For Each shp In Sheets("Sheet1").Shapes
Sheets("Sheet1").ListBox1.AddItem (shp.Name)
Next shp
End Sub
 

Watch MrExcel Video

Forum statistics

Threads
1,123,258
Messages
5,600,565
Members
414,389
Latest member
MarkElla

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top