Data Input Form question

NoSparks · #1 03-31-2017, 09:57 PM

It appears to me the Order sheet column B has pretty much the same stuff.

Not knowing how you use the file have to wonder if the userform shouldn't be writing to there.

Your Auto_Open sub populates AC11:AC16 from U11:U16

Removed the ControlSource and RowSource from the text/combo box properties
Set default property of Submit button to false
Populate Country combo at Userform_Initialize
Populate State combo from County_Change
Submit button writes to next row on GrpRecords sheet, same as previous, now also writes to Calcs U11:U16
Don't think anything else changed

Cyberseeker · #2 04-01-2017, 02:52 AM

Quote:

Originally Posted by NoSparks

It appears to me the Order sheet column B has pretty much the same stuff.
Not knowing how you use the file have to wonder if the userform shouldn't be writing to there.

Your Auto_Open sub populates AC11:AC16 from U11:U16

Removed the ControlSource and RowSource from the text/combo box properties
Set default property of Submit button to false
Populate Country combo at Userform_Initialize
Populate State combo from County_Change
Submit button writes to next row on GrpRecords sheet, same as previous, now also writes to Calcs U11:U16
Don't think anything else changed

Thanks,

working well now. I get lost with 'initializing' and the such.

Cyberseeker · #3 04-01-2017, 03:12 AM

Quote:

Originally Posted by Logit

Here are a few things I've reviewed and have questions about. These questions ...

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

Why ?

A friend built this macro. Im not sure which textboxes he was meaning here.

Quote:

Originally Posted by Logit

On UserForm but not on GrpRecords :

Denomination

Why ?

Column 'T' on GrpRecords

Quote:

Originally Posted by Logit

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

Sounds like it might be a plan. Can you explain how this would behave? A hypothetical example maybe?

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Automatically copy/paste a form field onto new pages, with user input included	Pindar	Word VBA	3	01-13-2017 11:49 AM
How to set font size in text-input field of protected form	UnicornVestibule	Word	5	06-06-2016 10:51 PM
My First Attempt at Form Creation: Input of Text via Check Box or Radio Button	tatihulot	Excel	0	08-15-2013 06:11 AM
Word only writes top half of input in form	Chippychap	Word	8	07-20-2012 12:49 AM
Data input in Powerpoint?	DeeDubb	PowerPoint	1	04-05-2012 01:53 AM