Disable copy/paste into form's textbox 1

Pcfred · Jan 14, 2008

I need to disable the ability to paste(Ctrl+V) into a textbox on a form in Excel(VBA). Basically I have operators scanning barcodes into a textbox and I want to force them to scan the barcode and not copy/paste the data into the textbox.

any ideas?

Thanks in advance,
PcFred

Andrzejek · Jan 14, 2008

Why not use a label instead? User cannot edit data in a label.

Have fun.

---- Andy

Pcfred · Jan 14, 2008

how do i set focus to a label so the scanner inputs the data?

SkipVought · Jan 14, 2008

Use the label CLICK event, or some other control logically related to the label.

Skip,
_{When a diminutive clarvoyant had disappeared from detention, headlines read...

Small Medium at Large}

Pcfred · Jan 14, 2008

VBA will not allow tabbing to a from a textbox to a label which the scanner automatically does after inputing data.

Thanks anyway guys.

Andrzejek · Jan 14, 2008

Cheat.
Put your text box outside of the Form's visible area so it is not visible to the user (if they cannot see it, they cannot modify it, right?), and in text box's _Change event put something like: Label1.Caption = TextBox.Text

You still can Set Focus to your text box.

Have fun.

---- Andy

Pcfred · Jan 14, 2008

that's sneaky and it just might work!

Thanks.

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Disable copy/paste into form's textbox 1

Pcfred

Technical User

Andrzejek

Programmer

Pcfred

Technical User

SkipVought

Programmer

Pcfred

Technical User

Andrzejek

Programmer

Pcfred

Technical User

Similar threads

Part and Inventory Search

Sponsor