I currently have an input box that when the user enters in a sheet name in the workbook, a specified range in the active sheet is copied to the sheet name entered in the input box. My code is as follows:
sname = InputBox("Name of sheet to copy to:", "Enter Sheet Name", dflt)
This works fine, but I need to add some radio buttons/check boxes that has a couple of options that the user of the workbook can select and depending on what is chosen depends what is copied ie. the comments in the active sheet.
Does anyone know how to create such input boxes that is able to do this?
Many thanks for taking the time to read my post and all suggestions will be welcome.
sname = InputBox("Name of sheet to copy to:", "Enter Sheet Name", dflt)
This works fine, but I need to add some radio buttons/check boxes that has a couple of options that the user of the workbook can select and depending on what is chosen depends what is copied ie. the comments in the active sheet.
Does anyone know how to create such input boxes that is able to do this?
Many thanks for taking the time to read my post and all suggestions will be welcome.