Need To Remind Input Box Types

[Bhawani]

Hi All,

I am working with VBA from past 9-12 months for automation but every time i work on inputbox(,,,,,type= i have to google for type 1,2,4,8,16,32 so i need to remind them all these or vba has another way to get it.


Regards,

 

[Marc L]

Hi !

No need Google, just read inner VBA help …
​

 

[NARAYANK991]

Hi Bhawani ,

If I have understood your question , you are right that Excel does not have any dropdown which allows you to select from the available values ; this is for reasons ; in brief I can say that one reason is because the setting can be a combination of values if you want that more than one kind of value is admissible.

However , if your requirement if for only one type of input , then see if this kind of workaround is acceptable.

Narayan