Hello everyone,

I am new to VBA and I have a problem I am trying to solve

I have a form which has sections that need to be constantly replaced and then reset.

An example of this would be:

"this [item] is [colour] and weighs [weight]"

which would become

"this house is blue and weighs 1g"

How do I make a function which will revert "this house is blue and weighs 1g" back to "this [item] is [colour] and weighs [weight]" ?

Hope that makes sense, any help is much appreciated!