Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with the basics. Starting out.
Ok, so I'm trying to make some objects and I realize that the things I'm
used to in Access do not carry over to Excel. I'm trying to make a user input box. I run a function, and it pops up a box asking for the user to input a password, masked by *'s. Masking it should be easy I assume. Just set the properties of the text box to PasswordChar = *. That's not the problem. What I need help with is this. A) Making the text box or control etc. Any way to get the user inputting something. B) Using this input to compare against other values in the module. So, say I do this. Dim passwordvalue as String I want the text box to be passwordvalue, so that I can compare it later like If (passwordvalue < "aaaa") Then Beep Else AuthUser() Hope that makes sense. Having a slow day at work, so I'll check back later in the day and maybe work on this throughout the day, depending on how much work comes in. Hooray for temping. O_o Thanks in advance. -Bob --- Message posted from http://www.ExcelForum.com/ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with the basics. Starting out.
Insert a UserForm Module
add Text Box add 2 buttons - OK & Cancel Set PasswordChar to * Dim passwordvalue as String at module or global level as required To display User form place this code in a macro UserForm1.Show Private Sub CommandButton1_Click() 'ok button passwordvalue = TextBox1.Text End Sub Private Sub CommandButton2_Click() ' cancel button End End Su -- Message posted from http://www.ExcelForum.com |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with the basics. Starting out.
Thanks! That works fine. I should be able to take that and move on t
more of the things I want to be doing with it. -Bo -- Message posted from http://www.ExcelForum.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
DSUM Basics | Excel Discussion (Misc queries) | |||
Visual basics | Excel Discussion (Misc queries) | |||
basics? | New Users to Excel | |||
Excel Basics | Excel Discussion (Misc queries) | |||
Starting a userform upon starting the file | Excel Programming |