Hi there,
I am trying to create Excel cell formulas that can use variables created during the execution of code in VB. In particular I would like to know if it would be possible to specify the sheet selection portion of the INDEX function based on a VB variable. For example,
If my basic INDEX...
I am trying to adapt some code that i ripped from the web to capture commands from multiple comboboxes in a userform, the ultimate goal being to allow them to utilise the same subroutine.
I have two comboboxes and have set the tags to "1" and "2" and am trying to get the...
Hi there,
I need to create multiple controls utilising the same subroutines in excel. After much web searching and head scratching i see that control arrays have been disabled in VBA. Can anyone help me to devise an alternative strategy to solve my problem? I am a very inexperienced programmer...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.