Extract number from name of cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to rename a cell that contains a control checkbox. the checkbox is named Checkbox2. I want to rename the cell "Box2". How do I extract the 2 from "Box2" so that I can use this in a loop?
 
This is an example of what I already have for my checkboxes. I would like to do something like this for my renamed cells such as Box2. Thanks. Mat

Dim nChkNum As Intege

For Each ole In OLEObject
If TypeOf ole.Object Is MSForms.Checkbox The
nChkNum = CInt(Mid$(ole.Name, Len("Checkbox") + 1))
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Deriving a name from variables 2
Copy from active sheet and paste into new sheet using info from cell in active 3
offset merged cell 10
Looping through checkboxes 1
Concantenate using VBA? 4
Looping checkboxes embedded in worksheet 1
Special characters via remote desktop 1
conditional formulas in Excel 5

Back
Top