Vba input.

[shaunsheep2345]

Hi, I'd like to create a quick method of adding vba to a userform.
The idea being I can just hit a button and insert a "part number" this will then add the code in txt box 1.(if partnumber. Value="1234" then msgbox "do not use" end if.
We have to add a few of these due to quality risks.
Any idea if the button idea is possible.

Cheers
Shaun.

[saravnepali]

Not quite clear where you would like to get the "part number" from - i assume its from some cells Say A1

Can we not use a simple command button on the form and put this code in there

Please Login or Register  to view this content.

[shaunsheep2345]

Not quite clear where you would like to get the "part number" from - i assume its from some cells Say A1

Can we not use a simple command button on the form and put this code in there

Please Login or Register  to view this content.

OK so some more thought into this.
Is it possible to have a code withtin the txtbox that will allow me to look up values in a range on a networked excel file. If it matches the value in the range from the txtbox a msgbox pops up with a statement. The statement will also be pulled from the networked excel sheet next to the fist value it found.
So if value 0987 is matched then msg check width or if value12 is found msg check height.
Could this work.

[Pepe Le Mokko]

Administrative Note:

Please don't quote entire posts unnecessarily. They clutter threads and make them hard to read.
Use the "Quick reply" instead
Thanks

[truk2]

I'm going to start with a cell formula approach, then give the vba equivalent.

The easiest place to start would be to start with a reference table that contains your logic.

ie in columns
"A" "B"
1223 "Check Width"
1234 "Do Not Use"
1134 "Use with caution"

Lets say that the part number is given in cell "C1".
If you use a cell to place your text messages you could use the formula

Please Login or Register  to view this content.

If you wanted that as a vba code, such as a function returning a text, the same approach would work

Please Login or Register  to view this content.

Or using a vba error handling approach

Please Login or Register  to view this content.

hence whenever if you want to set the warning in textbox2 when the value of textbox1 changes in a userform

Please Login or Register  to view this content.

I hope that this helps

[saravnepali]

Try this

If it doesn't work please attach the spreadsheet

Please Login or Register  to view this content.

[Pepe Le Mokko]

@saravnepali

If it doesn't work please send me the spreadsheet

Please do not ask members to send information to you personally. All information on this forum must stay public and accessible to all our members.

[saravnepali]

Apologies

I still meant through the forum.

I will try to maintain the wording accordingly.