Need to capture data from 2nd column based in 1st column selection Userform.

Hi all,

I am looking for a bit of help on a project I am updating. In short, I have a user form that is referencing patient insurance data when we do a procedure. At the moment, the billing folks would like us to sub-divide into 2 groups based on the selection made. On a worksheet I have a named range I reference as "insurance." When I make my selection from the listing, I need to know the "classification" from the adjacent cell.

Example: Medicare G0453
BC/BS 95941

Insurance coding determines how we calculate time on service. G-code billed 15 min units, 95941, billed by hour, rounded to nearest.

I am looking for some helpful code that may get me on the right track. What I currently have is not quite getting me there.

Please Login or Register  to view this content.

To help make sense of this mess: Userform has 5 total boxes for time. Start Time, End Time, Calculated Total minutes, 95941 is billed in whole hours, rounded. G-code is billed in 15 min increments.

I will bill only one or the other, so I am wanting the time to auto calculate and place in to proper textbox.

Thank you for your assistance.

Patrick

Here is a stripped version of my workbook. The issue I am wanting to solve has to do with time calculation. On !Data A51:A78 are insurance company names. Column B51:B78 has one of 2 identifiers that classify how the time is billed. 95941 code is for billing 1 hour increments, rounded to the nearest whole. G0453 code is to bill in 15 min increments, rounded to the nearest 15min. On my UserForm I have tb_95941 which I would like to populate with the calculated time in rounded whole hours from the tb_totalmin box when the 95941 is next cell to the insurance selection. When the G0453 is next to the selected insurance, I would like the calculation to be 15 min rounded increments into the tb_Gcode box. Ideally, it should be one or the other, not both calculated and displayed.

Hope this provides a bit more to go on.

Thank you for your help.

Patrick

Yes, Sir.

Thank you very much. After seeing how you addressed the issue, I was glad to see I wasn't too terrible far from the mark. Thanks again for the help. This one is solved. :-)

Regards,
Patrick