LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27
Default Userform Textbox in Password Validation

Hi, everyone -

I'm in the middle of a large project in the form of developing a
Timesheet for my organization. With a help of a lot of people here, I
think a lot of the work and formatting is done.

The timesheet itself is based on a large table using VLookup with
table column for employee number, employee name,..... and timesheet
password. I have created a number of userforms and command buttons to
perform several taskings.

The problem I'm having now is to enable the timesheet to be validated
& sent electronically instead of printing it out and passing it around
(paperless process). I have a userform that now includes a textbox
(for the employee to enter their individual timesheet password), a
command button (to valodate the employee's password), a command button
(to save the worksheet) and a third command button (to close the
userform). The second and third buttons have already been coded. What
I'm looking for is assistance in how to develop code to validate the
employee's password - the password typed in the textbox.

I'm thinking of, maybe, using IF statements in the code to compare the
VLookup table's Cell A1 (which indicate employee number) and the
column including individual passwords. Would this be the easiest way
to do it?

The last issue would be, once the employee's password is validated, to
have the employee's name populate the "Employee's Signature" cell in
the timesheet itself - make it look fancy by script font,.....

Can anyone help me out on my "final" problems with my project?

Thanks for your continued assistance.

Golf
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
WordWrap a TextBox on a UserForm dcornett63 Excel Discussion (Misc queries) 2 April 22nd 10 09:35 PM
Add COUNTIF TO USERFORM TEXTBOX Richhall[_2_] Excel Worksheet Functions 4 September 16th 09 11:43 AM
userform textbox Phil Excel Worksheet Functions 5 January 16th 05 06:59 PM
Help with Syntax UserForm TextBox John Wilson Excel Programming 1 July 28th 03 04:15 PM
Populating Textbox in UserForm Derek[_2_] Excel Programming 3 July 10th 03 10:41 PM


All times are GMT +1. The time now is 01:27 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"