VBA Password Input with Cancel Function

by

the standard InputBox returns empty fields and cancel the same way

No it does not. It returns a null pointer (vbNullString) on cancel and an empty string ("") for empty input.

Dim s As String
s = InputBox("Test")

If StrPtr(s) = 0 Then
  'Cancel pressed
Else
  'Ok pressed
End If

Because InputBoxDK returns the InputBox‘s value unchanged, same logic applies to it.

More Related Contents:

  1. to make this code simpler
  2. VBA code takes long time to execute in excel
  3. Wait until ActiveWorkbook.RefreshAll finishes – VBA
  4. Excel column number from column name
  5. Pop up the Excel Statusbar?
  6. Excel VBA deleting rows in a for loop misses rows
  7. Execute a command in command prompt using excel VBA
  8. What is the lifetime of a global variable in excel vba?
  9. Download attachment from Outlook and Open in Excel
  10. What is the most efficient/quickest way to loop through rows in VBA (excel)?
  11. Embed picture in outlook mail body excel vba
  12. How to check for empty array in vba macro [duplicate]
  13. Use autofilter on more than 2 criteria
  14. What is the function of FormulaR1C1?
  15. Compiler Error: User-defined types not defined
  16. Open a workbook using FileDialog and manipulate it in Excel VBA
  17. Excel VBA – Combine rows with duplicate values in one cell and merge values in other cell
  18. Vba Excel do vlookup from a closed file
  19. excel hyperlink to nothing
  20. How to add headers to a multicolumn listbox in an Excel userform using VBA
  21. How to send files via HTTP_POST with Excel using VBA?
  22. VBA to open Excel hyperlink does not work when hyperlink generated with a formula
  23. How to Add Date Picker To VBA UserForm
  24. Vba macro to copy row from table if value in table meets condition
  25. Difference between Thisworkbook.name and Activeworkbook.name in VBA
  26. Set a cell value from a function
  27. How to break a long string into multiple lines
  28. Read VBA macros (or vbaProject.bin) of an Excel file without opening it in MS Excel [closed]
  29. simple vba code gives me run time error 91 object variable or with block not set
  30. VBA inheritance, analog of super

Leave a Comment