Hello,
I have a userform with 6 textboxes.
When a textbox is cleared (with a commandbutton), I want this textbox is filled with the first next cell (with condition that the corresponding cell in the third column has a 1.
forum.ozgrid.com/index.php?attachment/62152/In the attachment an example.
What I want is when a textbox is cleared, the next value loads in this "free" textbox.
Thanks in advance.
aisietie
Re: Find empty textbox on userform
I think what you're wanting is something along these lines?
Private Sub CommandButton1_Click()
Cells.Find(What:=TextBox1.Value, After:=ActiveCell, LookIn:= _
xlFormulas, LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:= _
xlNext, MatchCase:=False, SearchFormat:=False).Activate
TextBox1.Value = ""
TextBox1.Value = ActiveCell.Offset(1, 0).Value
End SubRe: Find empty textbox on userform
Hello,
In the attachment a newer version of the file.
The problem is that even textboxes and labels are not filled.
Aso I cannot findout how a variable can be set, for rembering from wich row the values in the textboxes and labels are coming.
Any help is more than welcome
aisietie
Re: Find empty textbox on userform
Your form is poorly designed. The textBoxes aren't even bigger enough to display the contents.
The TwextBoxes are different sizes.
The Controls are horizontally level.
I think your whole idea is not really practical. Every time a TextBox is cleared you would need to run code that would determine which data is shown and what cell to use for the newly emptied TextBox.
Re: Find empty textbox on userform
royUK,
I realize the form is very poorly designed.
At this point I just want the technology get to work.
And yes, I am afraid that indeed, every time a textbox is cleared, it will be needed to run the code.
I want to apologize for the design, but ask for understanding my question for help, to solve the problem.
Thanks in advance.
aisietie
Re: Find empty textbox on userform
is this loading correctly?
TAs for design, it takes a few minutes to align and size textBoxes.
Re: Find empty textbox on userform
This version will remove the entry using the CommandButton. It is set up for CommandButton1 - to make it work for each button add number the button's tag, 1,2 etc and copy the code from Button1 to all the buttons
Re: Find empty textbox on userform
royUK,
Loads perfectly, works perfectly.
Great job! Thanks.
aisietie
Re: Find empty textbox on userform
rouUK,
I have a problem with:"add number the button's tag, 1,2 etc"
I cannot find how to let it work.
Can you put me on the road?
Thanks
aisietie
Re: Find empty textbox on userform
I found it, it was in the button properties to set it
Srry
Don’t have an account yet? Register yourself now and be a part of our community!