User Form Security Question

  • Thread starter Thread starter harpscardiff
  • Start date Start date
H

harpscardiff

Hi,

I'm creating a form, which onces completed transfers the data over to
the spreadsheet. But the guys in work don't really pay much attention
to what they have entered , so i was wondering is there any way to make
the user double check every entry?

I was thinking, once the user clicks ok, a msgbox would appear giving
the user the value they entered, click ok if correct or cancel to
amend.

Is there a easy way to do this?

Cheers.
 
Good afternoon harpscardiff

You've not give much information re what sort of controls you are using
on your userform (textboxes, listboxes, checkboxes etc?) so this answer
is a bit on the general side.

msg=""
msg = msg & "You have entered :" & TextBox1.Value
response = MsgBox(msg, vbYesNo)
If response = vbYes Then
' user clicks yes
End If
If response = vbNo Then
' user clicks no
End If


Does that help?

DominicB
 
If you're using a form, you're going to have to use VBA to check the
validity of the user's data. I do this frequently: for example, to check the
year that a patient was admitted to a hospital. If the year is 2105, there's
a good chance that the data isn't valid.

An alternative -- and I think it's a good one -- is to forego the form and
have the user enter the data directly on the worksheet. If you do that, you
can use Data | Validation to limit a user's input to values that you want to
permit.

--
C^2
Conrad Carlberg

Excel Sales Forecasting for Dummies, Wiley, 2005


"harpscardiff" <[email protected]>
wrote in message
news:[email protected]...
 
Conrad said:
If you're using a form, you're going to have to use VBA to check the
validity of the user's data. I do this frequently: for example, to
check the
year that a patient was admitted to a hospital. If the year is 2105,
there's
a good chance that the data isn't valid.

An alternative -- and I think it's a good one -- is to forego the form
and
have the user enter the data directly on the worksheet. If you do that,
you
can use Data | Validation to limit a user's input to values that you
want to
permit.

--
C^2
Conrad Carlberg

Excel Sales Forecasting for Dummies, Wiley, 2005


"harpscardiff"
<[email protected]>
wrote in message
Click to expand...

Thanks for your reply guys, much appreciated......apologies for the
limited data.

Just to add to my mail.....the form has 5 Frames
Frame 1 (user details) = 2 text boxes
Frame 2 (Client Details)= 5 text boxes
Frame 3 (Payment Details)= 3 text boxes and 2 list boxes
Frame 4 (Monetary Details) = 2 text boxes
Frame 5 (Address and Banking Details)= 13 text boxes.

The form was just a spreadsheet before, but still had problems, only
thing that worked was the date being correct.

DominicB, I can see what the msgbox do, but if the user click no, is
there any way to go to the text box and edit the value?

Thanks again.
 
Back
Top