Question Inputbox in Excel VBA

Dear Roller,

I hope can get assistance from you.

I want user to key in password. how i want to replace password that user key in to '*' or any other character in the input box?

Password char if not mistaken.

The input box on the vba form has a property called password. Use that property to set the character such as *.

Dear Roller,

How about inputbox from script in ExcelVBA like below:

Password = Inputbox ("Enter Password")

After i run the macro button, How I want to ensure that the password that we type appear as char "*".

It is not possible with inputbox. You have to create a user form and add a textbox on it to be able to use the password property. Build your own input box.