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.

Please Login or Register  to view this content.

and passing the rspn to

Please Login or Register  to view this content.

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.

Please Login or Register  to view this content.

**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

Please Login or Register  to view this content.

Please Login or Register  to view this content.

help passing textbox value from user form to variable

LinkBack

Thread Tools

Rate This Thread

Display

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

[SOLVED] User Form value passing problem

Bookmarks

Bookmarks

Posting Permissions