Find A Cell Between Row And Column.

Closed
azmiismail Posts 17 Registration date Thursday March 3, 2011 Status Member Last seen July 20, 2011 - Mar 23, 2011 at 01:40 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Mar 23, 2011 at 10:58 AM
Hello,

Can anyone provide me with a VBA code and guide me so that I'm able to input a data in a cell by reference to data at the column and row after clicking a Find/Input button at my combo box
Example is based on the table below,

Row reference
cell A2 and A3(merged become A2)=7777
cell B2 = +
cell B3 = -
cell A4 and A5(merged become A4)=3333
cell B4 = +
cell B5 = -
cell A6 and A7(merged become A6)= 1111
cell B6 = +
cell B7 = -

columns reference,
cell C1= 1
cell C2 = 2
cell C3 = 3

My combo box look like this
Label 1 = To input 1,2 or 3(Find)
Label 2 = To input 7777,3333 or 1111(Find)
Label 3 = To input +(Find and Input)
Label 4 = To input -(Find and Input)
**for label 3 and 4 boxes, it can be to input either one or both

and,
a Find/Input button in the left
Close button in the right


when I input "1" , "1111" and a value say "0.50"(to be place in "+ " box)into their respective box in my combo box and click the Find/Input button,it will insert 0.50 into cell C6 of my table,
when I input "3","3333" and value say "1.60"(place in the "-" box),it will insert 1.60 into cell E5,and
if I input "2","7777" and value say "44.45" place into "+" and "126.88" place into "-" ,it will insert 44.45 into cell D2 and 126.88 into cell D3 in my table.

I am still very much in the learning curve with macro and VBA ,kindly help me out to prepare for my upcoming projects.
Thanks.

1 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Mar 23, 2011 at 10:58 AM
Could you please upload a sample EXCEL file WITH sample data, macro, formula , conditional formatting etc on some shared site like https://authentification.site , http://docs.google.com, http://wikisend.com/ , http://www.editgrid.com etc
AND post back here the link to allow better understanding of how it is now and how you foresee. Based on the sample book, could you re-explain your problem too.


Note:
your data need not be to be real data but a good representative of how data looks like
0