Value from Form to last used row of a range

[vijehspaul]

Hi,
I am trying make a excel form with two drop down selections (category, sub category) to get some data from user. Drop down - sub category is based on category selection. I need user to enter some amount in the space provided. When 'OK' is clicked i want the sub category and rate to be filled to database section of the workbook.
Please have a look in the attached excel file.
In this case, i am able to find the location of database area but dont know how to find empty row and fill data to it. (empty row of the corresponding category area)

Thanks in advance.

 

[sn152]

Hi,

Check this.

 

[vijehspaul]

Thanks SN152.

But, i was looking for something else.
In my original sheet, I can get the address of the cell from which the data should be filled.

Dim rCount As Long
With Sheets(3).Range("a1:z1") 
    Set r = .Find(combo_cat.Text, LookIn:=xlValues)
    temp = r.Address

but I am not sure how to use this 'temp' (having the cell address- $c$1) to find last row from that cell

rCount = Sheet3.Cells(Rows.Count, temp).End(xlUp).Row
' this is not working though !!!

need some more help.

 

[Somendra Misra]

Hi,

See this file.

Regards,

 

[vijehspaul]

Wow.... This fulfills my quest.
Thanks a lot Somendra....


I knew, that me like people who have very less coding knowledge also can find solution here. Great going guys....

 

[Somendra Misra]

Glad you solved it. Welcome back anytime!!!

Regards,