m_in_spain
Board Regular
- Joined
- Sep 28, 2018
- Messages
- 72
- Office Version
- 365
- Platform
- Windows
Hi, I have the following simple line of code:
Ingredients4 is a listview, I have a variable, Dim k as Integer.,Ch4Actual is the UserForm
My question: Is it possible to replace the number 4 in my code with k so i can easily change a whole page of code which uses this line many times?
i have tried things like:
("Ch & k & Actual.ingredients & k").Visible = True
but no luck!
Many thanks for any advice or help
VBA Code:
Ch4Actual.ingredients4.Visible = True
Ingredients4 is a listview, I have a variable, Dim k as Integer.,Ch4Actual is the UserForm
My question: Is it possible to replace the number 4 in my code with k so i can easily change a whole page of code which uses this line many times?
i have tried things like:
("Ch & k & Actual.ingredients & k").Visible = True
but no luck!
Many thanks for any advice or help