Data Input Form question

Logit · #6 03-29-2017, 06:53 PM

Code:

Sub OpenHarvestForm()  			'<-- sub name
 
 Application.WindowState = xlMinimized  '<-- minimzes the entire excel workbook
 frmHarvest.Show                        '<-- makes userform visible
 Application.WindowState = xlMaximized  '<-- makes  excel workbook full sized

 ActiveWorkbook.Sheets("GrpRecords").Activate  
 '^^^^ "Activate" prepares sheet GrpRecords for receiving actions such as writing data to it
 
End Sub

What you need to do is right click the sheet tab / view code.

When the VBA editor window opens you want to right click on the icon FORM (see arrow)
Then View Code.

https://www.amazon.com/clouddrive/sh...hare_link_copy

The code displayed in the large window changes how the various controls on the form function.

If you just view the form itself (so it shows in the right hand window) you can edit the controls, labels and positioning of each.

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode 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