myasir1992
New Member
- Joined
- May 12, 2022
- Messages
- 4
- Office Version
- 2016
- Platform
- Windows
Hello Everybody,
I have created a VBA program where I have a sheet named "Purchase Roll". I have a data validation that includes
1.) Store Location.
2.) Supplier No.
3.) Rate Selection.
4.) Invoice/Bill No.
5.) Date.
I have 2 questions:
1.) My question is regarding #3 Rate selection where I have 2 choices for the user i.e. "From the price list" or "Manual". Now if user selects "From the price list" the serial number that is showing in the Document No. appears but when somebody selects "Manual" nothing appears. Why?
2.) Another question is when somebody selects "From the price list" it displays the serial number which the system should be getting from the cell # AA1 but it is picking some random number.
Kindly resolve these 2 issues as soon as possible. I will be very grateful to you.
Waiting for your response.
I have created a VBA program where I have a sheet named "Purchase Roll". I have a data validation that includes
1.) Store Location.
2.) Supplier No.
3.) Rate Selection.
4.) Invoice/Bill No.
5.) Date.
I have 2 questions:
1.) My question is regarding #3 Rate selection where I have 2 choices for the user i.e. "From the price list" or "Manual". Now if user selects "From the price list" the serial number that is showing in the Document No. appears but when somebody selects "Manual" nothing appears. Why?
2.) Another question is when somebody selects "From the price list" it displays the serial number which the system should be getting from the cell # AA1 but it is picking some random number.
Kindly resolve these 2 issues as soon as possible. I will be very grateful to you.
Waiting for your response.