any answers please
any answers please
would anybody be able to help me with this question
the file already has the user form all i'm trying to do is incorporate this code in to this user form
Any updates would someone be able to help me please ?
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.
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.
how can i replicate this code for check boxes
if the text box next to the check box is empty hide the check box ?
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
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
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 ?