Solved

Access Object Property from VBA Module in Excel 2010

Posted on 2016-11-09
2
27 Views
Last Modified: 2016-11-09
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.
0
Comment
Question by:Terry Rogers
2 Comments
 
LVL 49

Accepted Solution

by:
Rgonzo1971 earned 500 total points
ID: 41880513
HI,

pls try
Dim cProgressBar1 As Object

Set cProgressBar1 = Sheet1.ProgressBar1 '// OR Worksheets("YourSheetName").ProgressBar1
cProgressBar1.Value = Counter

Open in new window

Regards
1
 
LVL 1

Author Closing Comment

by:Terry Rogers
ID: 41880800
Worked a treat. Thank you! :)
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Modern/Metro styled message box and input box that directly can replace MsgBox() and InputBox()in Microsoft Access 2013 and later. Also included is a preconfigured error box to be used in error handling.
Since upgrading to Office 2013 or higher installing the Smart Indenter addin will fail. This article will explain how to install it so it will work regardless of the Office version installed.
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

920 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now