How to implement "Or statement" in my excel VBA Program

myasir1992

New Member
Joined
May 12, 2022
Messages
4
Office Version
  1. 2016
Platform
  1. 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.
 

Attachments

  • 1652799848508.png
    1652799848508.png
    165.1 KB · Views: 18
  • 2022-05-17 (1).png
    2022-05-17 (1).png
    164.3 KB · Views: 18

Excel Facts

Add Bullets to Range
Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)

Forum statistics

Threads
1,223,228
Messages
6,170,871
Members
452,363
Latest member
merico17

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
Back
Top