Solved Password character for InputBox Function

[Sarah.M]

Hi, Plz note, My VBA is blocked by IT for security reason (Cybersecurity).
I can use only Expression builder, Macros, Queries, Tables, Forms and Reports only.
------------------------------------------------
Inputbox is very useful, but the numbers are visible, is it possible to let input box for password to show the numbers as *****
or is there any alternative to InputBox function that can be used with Password?
plz help

 

[arnelgp]

create a form similar to your input box.
add formatting to the Textbox (password).

 

[arnelgp]

like i said you can create the form.
you can add a macro that will open this form and
supply the Caption, the Prompt and the Default value (see mcrInputBox).

run the macro.

the Return is either (Null or "", if Cancel is pressed) or the value typed.
this value is saved in Tempvars!InputValue.

If Len(Tempvars!InputValue & "") <> 0 Then
Debug.Print TempVars!InputValue
End If

 

[Sarah.M]

AWESOME!
Thanks!