ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Form help (https://www.excelbanter.com/excel-programming/387400-form-help.html)

Dave M[_2_]

Form help
 
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?


All times are GMT +1. The time now is 04:39 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com