Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Data Entry Form (similar to default Excel DataForm)
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating a data entry form in excel | Excel Worksheet Functions | |||
Excel as data entry form? | Excel Discussion (Misc queries) | |||
data entry form Excel | Excel Discussion (Misc queries) | |||
format data displayed on Excel data entry form | Setting up and Configuration of Excel | |||
data entry form in excel | New Users to Excel |