Link to home
Start Free TrialLog in
Avatar of Terry Rogers
Terry RogersFlag for United Kingdom of Great Britain and Northern Ireland

asked on

Access Object Property from VBA Module in Excel 2010

I have a module in VBA code in an Excel 2010 spreadsheet.

The spreadsheet has multiple worksheets.

On one worksheet I have placed a "Progress Bar ActiveX Control".

I need to be able to update the current value of this control from my module, but can't work out the correct code.
ASKER CERTIFIED SOLUTION
Avatar of Rgonzo1971
Rgonzo1971

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Terry Rogers

ASKER

Worked a treat. Thank you! :)