Posts by aisietie

file

An example

Thanks, the code works fiine but gives problems when the strings to compare are long or when there are to many rows to compare.. Other problem is when a blank row is in the data, then the macro stops.

Hello,

I have 2 sheets. Sheet 1 contains names in column B next to "info" in Column C.
Sheet 2 contains only the "info" in Column C. I want to compare the info on sheet 2 with the info in sheet 1.
The possibilities are, the info in Column C in sheet 2 exist in sheet 1, then copy the row to sheet 3, the "info" (row) in sheet 2 does not exist in sheet 1, then copy row ffrom sheet 2 in sheet 3, the info in sheet 1 does not longer exist in sheet 2, then do nothing.
See the attachement.

Thanks in advance
aisietie

Re: Found string in text in column C and copy the founstring in adjacent cell in colu

Stephen,

With the function it works allright.

Thanks for that!!

Aisietie

Re: Found string in text in column C and copy the founstring in adjacent cell in colu

Stephen,

Thanks, but yes there can be numbers before the B0 string.....

Aisietie

Re: Found string in text in column C and copy the founstring in adjacent cell in colu

Hello,

See the attachment.

Thanks

aisietie

Hello,

I'd like to scan a column C, with text, for a certain string that begins with "B0" folowed by 4 digits and put the found string (e.g. "B01574") in the adjacent cell, each time it finds the string. In this case, "B01574"
The string can be anywhere in the text.
The formula =If(ISERROR(SEARCH("B0****",C1,1)),"","B0****") is not working, when a B0 string is found, the result is B0****

Thanks for the help

aisietie

Re: Save workbook with name cells text

Derk, Batman,

Thx, that works perfectly.

Grtz

aisietie

Hello,

I want to save an excel workbook with the text of 3 cells in the name.
Cells C6, B9 and C9 are the cells who contains the info.
So I want to save the workbook like:

NewName = Sheets("Appreciation").Range("C6 & B9 & C9").Text

But the range is not recognized.
What is the right code?

Thanks in advance
aisietie

Re: Find empty textbox on userform

I found it, it was in the button properties to set it

Srry

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

royUK,

Loads perfectly, works perfectly.

Great job! Thanks.

aisietie

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

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

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: Check values cells with Formula or vba?

Batman, tinbendr, S O, jindon,

Thanks 4 the different solutions.
My question is well answered, and now I am looking wich solution I will take.

I can only say, thank you verry much.

aisietie

Re: Check values cells with Formula or vba?

Batman,

That works OK
The W142 is not correct. W122 is correct.
What is there to be added - changed, when the possibility exists that the 1 st cell has a 0.
it can occur,
Thanks 4 the note, and thanks 4 the solution.

aisietie

Hello,

I have 7 cells to be controlled
T2 - T22 - T42 - T62 - T82 - T102 - T122
Values can be 0 or 1
When values are respectively
1-0-0-0-0-0-0 then Cell W2 = 1
When values are respectively
1-1-0-0-0-0-0 then Cell W2 = 0 W22 = 1
When values are respectively
1-1-1-0-0-0-0 then Cell W2 = 0 W22 = 0 W42 = 1
.
.

When values are respectively
1-1-1-1-1-1-1 then Cell W2, W22...W102 = 0 W142 = 1
How can this be done?
Thanks for the help.
aisietie

Re: Difference in Months between dates

thx, snb, that is it!

aisietie