Solved

Access Object Property from VBA Module in Excel 2010

Posted on 2016-11-09
2
32 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

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

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

Introduction This Article briefly covers methods of calculating the NPV and IRR variants in Excel as well as the limitations in calculating and interpreting IRR results. Paraphrasing Richard Shockley, author of my favourite finance reference tex…
This tutorial explains how to create a series of drop-down lists that are dependent upon prior selections to guide (“force”) the user to make the correct selection and reduce data errors within Microsoft Excel. Excel 2010 was used for this tutorial;…
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

825 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