msgbox/inputbox with worksheet name radio buttons?

[compulsiveguile]

Is there a way in VBA to create an input box with a radio button list of all the worksheets/tabs available in the current workbook?

I want the user to select just one of the tabs without having to type in the title of the label exactly. This normally wouldn't be a problem, but there are so many tabs in this particular workbook that you'd have to memorize the label name, as you might not be able to see it without scrolling (which is disabled due to Application.ScreenUpdating = False) to the right or left.

Any solution(s) would be welcomed. Thanks!

[dominicb]

Good afternoon compulsiveguile

There is no ready made solution to do this within VBA - you're going to have to programatically build a userform and then populate it, which can be done, but is no easy task.

However, John Walkenbach has built a wrapper routine which he discusses here, and the attached file I have built using the downloaded workbook he makes available here.

HTH

DominicB

[compulsiveguile]

I figured it might be a little complicated...

I might check into what you posted a bit later. As for now, I guess what I have will have to suffice.