Conditional InputBox

obener

Board Regular
Joined
May 31, 2009
Messages
118
Hi All,

I wanted to know if there was any possibility of using a inputbox but the user has a choice of either entering the data using the keyboard or use external device such as a barcode scanner? I thought about using an inputbox to select the interface to use each time but I wanted it to be usable not a pain going through the same thing every time.
 

Excel Facts

Excel Can Read to You
Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.

Tom Urtis

MrExcel MVP
Joined
Feb 10, 2002
Messages
11,239
The two input methods are so different, in my opinion you should just settle on one or the other depending on the context of the workbook design and what your end users will find easiest. I would not try incorporating both, just pick one and your project will be simpler to people using it.
 

Watch MrExcel Video

Forum statistics

Threads
1,129,685
Messages
5,637,798
Members
416,983
Latest member
LessThanAverageUser

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top