I need to create a data entry form similar to the default one Excel
provides via DataForm and pass Range values into the data entry
TextBox.
I'm scaning 1-to-12 new employee# (barcode#) into 37 ranges
(work_crews). The default DataForm works, but is too cumbersome
having to be reloaded each time of the 37 work_crew ranges change.
I've created a form with CommandButtons that selects the crew_range as
active, and I'd like to pass these ranges to a TextBox for data entry
of the employee#s...
Any help will be greatly appreciated...as I'm relatively new to VBA
Thanks,
tonydm
Attached: My_DataForm.doc with CREW_1 & CREW_3 selected & Excel's
default DataForm...with Crew_Ranges (1 & 3) chosen by a Select_Crew
CommandButton.
+-------------------------------------------------------------------+
|Filename: My_DataForm.doc |
|Download:
http://www.excelforum.com/attachment.php?postid=3901 |
+-------------------------------------------------------------------+
--
tonydm
------------------------------------------------------------------------
tonydm's Profile:
http://www.excelforum.com/member.php...o&userid=28006
View this thread:
http://www.excelforum.com/showthread...hreadid=475148