abdelfattah
Well-known Member
- Joined
- May 3, 2019
- Messages
- 1,429
- Office Version
- 2019
- 2010
- Platform
- Windows
hello
i have data in sheet1 begins range from a2:c10 and userform contains 3 textbox the column c contain values when i fill data in textbox3 and press enter i would show the message " avalible is 200 or 300 or500.etc if the entered number in textbo3 more than what in column c
my code doesn't work well it gives me the first value in c in every time i choose specific brand
for in stance
my data in sheet:
a b c
<tbody>
</tbody>
i fill these data in textbox1,2,3
textbox1= a , textbox2=b textbox3=c
it suppose when i fill the brand in textbox2 = "1200r20" and the quantity textbox3 ="500" then gives me the message " availible is 200" and so the rest the brands
i have data in sheet1 begins range from a2:c10 and userform contains 3 textbox the column c contain values when i fill data in textbox3 and press enter i would show the message " avalible is 200 or 300 or500.etc if the entered number in textbo3 more than what in column c
my code doesn't work well it gives me the first value in c in every time i choose specific brand
for in stance
my data in sheet:
a b c
ITEM | BRAND | QUNTITY |
1 | 1200R20 | 200 |
2 | 315/80R22.5 | 300 |
3 | 1400R20 | 100 |
<tbody>
</tbody>
i fill these data in textbox1,2,3
textbox1= a , textbox2=b textbox3=c
it suppose when i fill the brand in textbox2 = "1200r20" and the quantity textbox3 ="500" then gives me the message " availible is 200" and so the rest the brands