VBA: Create a Form Controls Spin Button

[zero269]

Hello,

This question is an extension from an erlier question here:

VBA: Get Spin Button Name

Hello, I'm looking for a way to get the name of a Form Controls Spin Button on a Worksheet, not in a Form. I'm working on a macro that builds a calendar, and I'm having to delete the button manually each time I want to clear everything and test my code. I'm trying to avoid deleting all...

www.mrexcel.com

This question was peremptivly answered, but I feel it deserves it's own thread for anyone searching for this specific question.
@Jaafar Tribak was kind enough to answer a question that was mentioned as an afterthought following a solution for that other thread.

His solution for this question is this specific post:

VBA: Get Spin Button Name

Hello, I'm looking for a way to get the name of a Form Controls Spin Button on a Worksheet, not in a Form. I'm working on a macro that builds a calendar, and I'm having to delete the button manually each time I want to clear everything and test my code. I'm trying to avoid deleting all...

www.mrexcel.com

Thank you and best regards,

 

[Jaafar Tribak]

As per the request of the OP, here is a link to the answer proposed in the original thread: Answer

 

[zero269]

As per the request of the OP, here is a link to the answer proposed in the original thread: Answer

Thanks Jaafar!