Write a VBA program to request the Product Number and Order Quantity from a user and enter that information into the Order sheet. Then thank the user for the information. Put a button on the Order sheet that permits the user to invoke this program.
B D 1 Category Product Number Description Quantity on-hand Janua 2 Desiccators 490620 2 cubic foot plastic dessicator cabinet. 85 3 Bath 490184 260010 refrigerated bench top bath with Pelletier thermoelectric cooling from ambient to 93 4 Spectrophotometers 490780 6 uv/vis spectrophotometer with computer monitor and printer. 8 5 Centrifuges 490432 centrifuge 94 6 Glove Boxes 490700 stainless steel 2-sided glove box with dual column gas dryer. 3 vacuum pumps and 2 rec 60 7 Bath 490174 tissue float bath. 48 8 Microscopes 490727 trinocular compound microscope with 4x 40x and 100x objectives. 14 9 Cell Disrupters 490292 (Thermal Spectronic) French Press complete with FA-030 cell (40 000 lbs) and rapid-fill ki 20 10 Microscopes 490713 10 4-10-40-100x oil microscope. 12 11 Microscopes 490714 10 4-40-100x plans microscope. 93 12 Desiccators 490613 10 inch diameter glass dessicator. Complete with plate and cover. 91 13 Desiccators 490614 10 inch diameter glass vacuum dessicator. Complete with plate and cover. 85 14 Analyzer 490004 1000 tablet? Hardness Tester 3 15 Spectrophotometers 490787 100-30-uv/vis spectrophotometer. 24 16 Spectrophotometers 490788 100-50 uv spectrophotometer. 14 17 Centrifuges 490361 1021 carrier 48 18 Centrifuges 490410 1024 cytobucket carriers for 1 x 3 inch microscope slides. For IEC 958 or 215 rotors. 26 19 Microscopes 490715 10x + 20x stereoscope 56 20 Evaporators 490628 113 multivp Nitro O 43 21 Biohood 490246 1184 Class 11A/B3 bio safety cabinet complete with stand. With new filters & current certi 52 22 Biohood 490247 1186 Class 11A/B3 bio safety cabinet complete with stand. With new filters & current certi 35 23 Bath 490146 12 x 18 inch with cover. 65 24 Spectrophotometers 490789 1234 Delphi fluorometer 99 25 Bath 490147 1235PC polymer coated water bath 11x20 inch chamber with cover. 59 26 Cell Harvesters 490330 1295-001cell harvester 14 27 Bath 490148 12x15 stainless steel bath with stainless steel cover 57 28 Bath 490149 14 20 x 15" plastic bath. 11 29 Balances 490070 1409 MP8 top loading electronic balance. Capacity 600 grams; sensitivity 0.01grams. 52 30 Bath 490150 14L-M dual action shaking water bath. 14 x 18 inch with SH AL dual action (orbital and re 83 31 Bath 490151 14x14x4 240v bath. 15 32 Centrifuges 490409 15ml Rotor. 77 33 Cell Disrupters 490296 1600 watt Polytron PT45-80 with tip. 6 34 Cell Disrupters 490297 16-850 ultrasonic 84 35 Autoclave 490037 16x26 cylindrical autoclave with generator. 37 36 Bath 490152 181 5x5 inch water bath. 56 37 Bath 490153 185 water bath with stainless steel cover. 18 liter capacity chamber. 11 1/2" x 19 1/2" x 6 45 Dacicestare 100C16 10 10 ise olactie docciestor chinnt 2. costuste Honor Code Instructions Order Report Data 20
