Posts by zzzzzzzzzzz

any answers please

thanks

would anybody be able to help me with this question

i disagree

the file already has the user form all i'm trying to do is incorporate this code in to this user form

hi

Any updates would someone be able to help me please ?

Quote from cytop

Re: make all empty textboxes invisible

Without knowing the relationship (For example - are all the textboxes using the default sequential names and are in order) between the textboxes there's no way to suggest how you could loop.

What you could possibly do (again, not really enough info to be sure) is populate the textboxes then loop though all controls setting those textboxes that are blank to be hidden.

Code

Dim c as Control


For Each c in Me.Controls
If typeName(c) = "TextBox" Then
c.Visible = (c.Text <> vbNullstring)
End If
Next

If there are other textboxes on the userform you do not want to be affected by this then you will have to add another check. Perhaps add a '*' to the tag property of those and check the Tag in the loop.

Display More

hi

how can i replicate this code for check boxes
if the text box next to the check box is empty hide the check box ?

hi

I would like to modify the spreadsheet to do the following

As you can see in the attached sheet, the user form will show everything in column "D".

There is a text box for each cell in column "D" ,in each text box there is also a check box that would clear that text box.

The goal is to click save data and any number that has been cleared should also be cleared in column "D"

I also want to do similar to what this codE is doing

[VBA]Sub clearcrfromcell()
Dim Num As String, V As Variant, Rng As Range
Num = InputBox("What number do you want to clear?")
For Each V In Split(Num, "-")
Columns("D").Replace V, "", xlWhole, , , , False, False
On Error Resume Next
For Each Rng In Columns("D").SpecialCells(xlBlanks).Areas
Rng.Offset(, 1).Formula = "=" & Rng.Offset(, -1).Address(0, 0)
Rng.Value = 0
Next
Next

End Sub[/VBA]

Besides clearing the numbers this code also goes to the cell to the right and puts a formula in there, i would like for this user form (save data) to do the same. how can i accomplish that ?

Thanks