I am trying to create a form to fill in information.

On my sheet I have data validation on two rows that are dependant on each
other.

First Row
=IF(G60,OFFSET(sectiontype2,MATCH(G6,sectiontypea ,0)-1,1,COUNTIFsectiontypea,G6),1),Unit)
Second Row
=IF(F60,OFFSET(unittype1,MATCH(F6,unittype,0)-1,1,COUNTIF(unittype,F6),1),Section)

I am trying to get the same sort of thing with a user form, and I'm having
problems trying to get it to work.

Any ideas?