Thread: [Solved] Data Input Form question
View Single Post
 
Old 03-31-2017, 08:12 PM
Logit Logit is offline Windows 10 Office 2007
Expert
 
Join Date: Jan 2017
Posts: 587
Logit is a jewel in the roughLogit is a jewel in the roughLogit is a jewel in the roughLogit is a jewel in the rough
Default

Here are a few things I've reviewed and have questions about. These questions
are not an attempt to be critical ... just need to have a better understanding of
where you were/are going with these items:


Quote:
On the Calcs Sheet U11:U16 being referenced on the UserForm Initialize event for
several of the Textboxes.

Why ?

Quote:
In the UserForm Initialize macro :

Country.Value
State.Value

Change to : Text Boxes

Then change the code to :

Country.Text = Sheets("Calcs").Range("U16").Value
State.Text= Sheets(:Calcs").Range("U14").Value

Quote:
On UserForm but not on GrpRecords :

Denomination

Why ?


Quote:
What are your thoughts why using this ?

If Denomination.Value = "" Then
Denomination.SetFocus
Else:
If Church.Value = "" Then
Church.SetFocus
Else
Web.SetFocus
End If

End If

Initially, I had alot of troubles trying to get the workbook to just load. Not certain why. It seems
to at least load ok now and I'm able to edit and review. Hopefully that will continue.
Attached Files
File Type: xlsm Fish Rev 1.xlsm (242.6 KB, 10 views)
Reply With Quote