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

Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.

Tom Urtis

MrExcel MVP
Joined
Feb 10, 2002
Messages
11,241
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,133,243
Messages
5,657,575
Members
418,401
Latest member
B_A_M155

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