Greetings, if I have a combination of text and numbers in a userform textbox, how would I tweak my code to ONLY send the text to a cell in a worksheet?
For example in my code snippet below the value in "deviceId" is "fire extinguisher 47". but I would like only the text "fire extinguisher" to be passed to the next blank cell in column B.
I know how to do this in a formula, but I have never done it in code. I appreciate any assistance - thank you
For example in my code snippet below the value in "deviceId" is "fire extinguisher 47". but I would like only the text "fire extinguisher" to be passed to the next blank cell in column B.
VBA Code:
.Range("B" & nextrow) = DeviceId.Value
I know how to do this in a formula, but I have never done it in code. I appreciate any assistance - thank you