I was wondering if there was a way to have a vba to scan something like:
1. ALBUTEROL *HFA*--INH 90MCG AERP REFILLS REMAINING: 0 #: 3
EXPANDED SIG: INHALE 2 PUFFS EVERY 4-6~HOURS AS NEEDED FOR
SHORT~BREATH ~
2. COMBIVENT--INH AERP REFILLS REMAINING: 1 #: 4
EXPANDED SIG: INHALE TWO PUFFS BY MOUTH~FOUR TIMES A DAY ~
3. CYCLOSPORINE (RESTASIS)--OPT 0.05% EMUL REFILLS REMAINING: 1 #: 2
EXPANDED SIG: INSTILL 1 DROP IN EACH EYE TWICE A DAY
4. HYDROCHLOROTHIAZIDE--PO 25MG TAB REFILLS REMAINING: 0 #: 30
EXPANDED SIG: TAKE ONE TABLET BY MOUTH EVERY DAY
And have the vba capture for example Albuterol up to refills and the expanded sig and place it in a textbox in a userform. Then continue to the next medication and put that medication in another textbox and continue until there are no more on the list average is 15 medications. The source of the information will be an active window.
1. ALBUTEROL *HFA*--INH 90MCG AERP REFILLS REMAINING: 0 #: 3
EXPANDED SIG: INHALE 2 PUFFS EVERY 4-6~HOURS AS NEEDED FOR
SHORT~BREATH ~
2. COMBIVENT--INH AERP REFILLS REMAINING: 1 #: 4
EXPANDED SIG: INHALE TWO PUFFS BY MOUTH~FOUR TIMES A DAY ~
3. CYCLOSPORINE (RESTASIS)--OPT 0.05% EMUL REFILLS REMAINING: 1 #: 2
EXPANDED SIG: INSTILL 1 DROP IN EACH EYE TWICE A DAY
4. HYDROCHLOROTHIAZIDE--PO 25MG TAB REFILLS REMAINING: 0 #: 30
EXPANDED SIG: TAKE ONE TABLET BY MOUTH EVERY DAY
And have the vba capture for example Albuterol up to refills and the expanded sig and place it in a textbox in a userform. Then continue to the next medication and put that medication in another textbox and continue until there are no more on the list average is 15 medications. The source of the information will be an active window.
