I'm trying create a floating text box that has the following information:
Key
RED = Warehouse
AMBER = Customer Services
YELLOW = Sales
GREEN = Complete
Unfortunately, when I run the VBA on the spreadsheet I get "Compile error: Method or data member not found". Here is the VBA coding I'm using:
Sub ShowTextBox()
UserForm1.TextBox1.Text = "RED = Warehouse" & vbLf & "AMBER = Customer Services" & vbLf & "YELLOW = Sales" & vbLf & "GREEN = Complete"
UserForm1.Show vbModeless
End Sub
When I get the error Sub ShowTextBox() is high lighted in yellow. I'm a real novice on VBA so this is a massive learning curve, if someone can help and explain in simple terms for a novice understanding that would be amazing.
Bookmarks