Works Great, Thanks Zathras
Just to clarifiy for others, the formula should have read:
=IF(F15,Instructions!$A$39/($F$15+$F$16+$F$17+$F$18),0)
Thanks again Zathras, I was getting too caught up on using VBA to solve every problem.
Thanks Zathras,
That almost has it, but I need to be able to differentiate between which cost code (which are the G15-G18 and the checkboxes) is checked on the userform, not just how many are checked. The user could check just G17 and G18, for example, and I would need to have 60 (using your...
Hey everyone,
I am having a bit of a problem with a userform. The goal is to allow the user to select which items he/she wants to divide the total contents of a cell to using checkboxes. i.e if the user selects two of the four checkboxes divide the cell by two and paste the values to the two...
Jim,
I used this in an application I am doing right now for the same thing.
Sub GetImportFileName()
Dim Filt As String
Dim FilterIndex As Integer
Dim FileName As Variant
Dim Title As String
Range("A1").Select
' Set up list of file filters
Filt =...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.