help passing textbox value from user form to variable

**mike760534211** · 07-29-2015, 01:09 PM

I am using the below code in the ThisWorkbook (Code) sheet to prompt for a pass phrase when the book is opened.

rspn = InputBox("Pass Phrase")

and passing the rspn to

If rspn = "password" Then 'code Else 'more code

I would like to use a user form so that I can hide the pass phrase that is typed in a text box and then pass that back to the ThisWorkbook (Code) as a varible to to verified by the below code.

If rspn = "password" Then 'code Else 'more code

**pjwhitfield** · 07-29-2015, 03:25 PM

create your form with a textbox and an OK button, in the OK button put your code

alternatively create the form and have the OK button call the Sub in ThisWorkbook, you can either store the value in a Public variable (declare it in Module 1), store the result of the textbox in a cell in the workbook and refer to that in the code or (I think the sensible one), pass the text into the Sub ie the code for the button is

CALL MySub Me.PasswordField

Sub MySub (ThePassword as string)
.
.
.

help passing textbox value from user form to variable

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

help passing textbox value from user form to variable

Re: help passing textbox value from user form to variable

Thread Information

Users Browsing this Thread

Similar Threads

First User Form needs help with using textbox input a variable in vba Macro

Passing values to a second user form.

Passing Values from User Form

Passing String Variable from Command Button Macro to a List Box in same User Form

Passing inputs from one user form to another

Passing variables from sub to user form

User Form value passing problem

Bookmarks

Bookmarks

Posting Permissions