Home |
Search |
Today's Posts |
#1
|
|||
|
|||
text box
I have created a text box, but when I type in something, and hit enter, I get
the error message "REFERENCE NOT VALID". Please help. Thank you |
#2
|
|||
|
|||
We require some more details. Where have you created the textbox, in the
sheet or a userform. Are you using the control from the Control Toolbox menu. Are there any macros you are using. Mangesh "Marlis" wrote in message ... I have created a text box, but when I type in something, and hit enter, I get the error message "REFERENCE NOT VALID". Please help. Thank you |
#3
|
|||
|
|||
I used the control toolbox to create the textbox in Excel. No macros.
Thanks "Mangesh Yadav" wrote: We require some more details. Where have you created the textbox, in the sheet or a userform. Are you using the control from the Control Toolbox menu. Are there any macros you are using. Mangesh "Marlis" wrote in message ... I have created a text box, but when I type in something, and hit enter, I get the error message "REFERENCE NOT VALID". Please help. Thank you |
#4
|
|||
|
|||
It could also be that you are trying to enter text from the formula line.
This make the data in the text box as a formula. Very cool for dynamic text boxes...not good if you want static data. You should be entering information in the text box itself. "Mangesh Yadav" wrote: We require some more details. Where have you created the textbox, in the sheet or a userform. Are you using the control from the Control Toolbox menu. Are there any macros you are using. Mangesh "Marlis" wrote in message ... I have created a text box, but when I type in something, and hit enter, I get the error message "REFERENCE NOT VALID". Please help. Thank you |
#5
|
|||
|
|||
just a wild guess. Please go to the VBE and check Tools References. Check
if there are any missing links. If yes, uncheck the ones which have missing. Do you get the same behaviour for any other control. Mangesh "Marlis" wrote in message ... I used the control toolbox to create the textbox in Excel. No macros. Thanks "Mangesh Yadav" wrote: We require some more details. Where have you created the textbox, in the sheet or a userform. Are you using the control from the Control Toolbox menu. Are there any macros you are using. Mangesh "Marlis" wrote in message ... I have created a text box, but when I type in something, and hit enter, I get the error message "REFERENCE NOT VALID". Please help. Thank you |
#6
|
|||
|
|||
This probably sounds like a dumb question, but should all of them be checked?
Only the first five are. It only does it with the text box. Thanks "Mangesh Yadav" wrote: just a wild guess. Please go to the VBE and check Tools References. Check if there are any missing links. If yes, uncheck the ones which have missing. Do you get the same behaviour for any other control. Mangesh "Marlis" wrote in message ... I used the control toolbox to create the textbox in Excel. No macros. Thanks "Mangesh Yadav" wrote: We require some more details. Where have you created the textbox, in the sheet or a userform. Are you using the control from the Control Toolbox menu. Are there any macros you are using. Mangesh "Marlis" wrote in message ... I have created a text box, but when I type in something, and hit enter, I get the error message "REFERENCE NOT VALID". Please help. Thank you |
#7
|
|||
|
|||
Hi,
No, not all should be checked. My only question was: If any of the current checked ones have a MISSING tag along, if so uncheck the box, otherwise let it be. Mangesh "Marlis" wrote in message ... This probably sounds like a dumb question, but should all of them be checked? Only the first five are. It only does it with the text box. Thanks "Mangesh Yadav" wrote: just a wild guess. Please go to the VBE and check Tools References. Check if there are any missing links. If yes, uncheck the ones which have missing. Do you get the same behaviour for any other control. Mangesh "Marlis" wrote in message ... I used the control toolbox to create the textbox in Excel. No macros. Thanks "Mangesh Yadav" wrote: We require some more details. Where have you created the textbox, in the sheet or a userform. Are you using the control from the Control Toolbox menu. Are there any macros you are using. Mangesh "Marlis" wrote in message ... I have created a text box, but when I type in something, and hit enter, I get the error message "REFERENCE NOT VALID". Please help. Thank you |
#8
|
|||
|
|||
No missing tag.
"Mangesh Yadav" wrote: Hi, No, not all should be checked. My only question was: If any of the current checked ones have a MISSING tag along, if so uncheck the box, otherwise let it be. Mangesh "Marlis" wrote in message ... This probably sounds like a dumb question, but should all of them be checked? Only the first five are. It only does it with the text box. Thanks "Mangesh Yadav" wrote: just a wild guess. Please go to the VBE and check Tools References. Check if there are any missing links. If yes, uncheck the ones which have missing. Do you get the same behaviour for any other control. Mangesh "Marlis" wrote in message ... I used the control toolbox to create the textbox in Excel. No macros. Thanks "Mangesh Yadav" wrote: We require some more details. Where have you created the textbox, in the sheet or a userform. Are you using the control from the Control Toolbox menu. Are there any macros you are using. Mangesh "Marlis" wrote in message ... I have created a text box, but when I type in something, and hit enter, I get the error message "REFERENCE NOT VALID". Please help. Thank you |
#9
|
|||
|
|||
What else do you have in your spreadsheet. Do you get the same behaviour in
a new file if you repeat the same steps. Do you have a pivot table in the file which gives you the error. Mangesh "Marlis" wrote in message ... No missing tag. "Mangesh Yadav" wrote: Hi, No, not all should be checked. My only question was: If any of the current checked ones have a MISSING tag along, if so uncheck the box, otherwise let it be. Mangesh "Marlis" wrote in message ... This probably sounds like a dumb question, but should all of them be checked? Only the first five are. It only does it with the text box. Thanks "Mangesh Yadav" wrote: just a wild guess. Please go to the VBE and check Tools References. Check if there are any missing links. If yes, uncheck the ones which have missing. Do you get the same behaviour for any other control. Mangesh "Marlis" wrote in message ... I used the control toolbox to create the textbox in Excel. No macros. Thanks "Mangesh Yadav" wrote: We require some more details. Where have you created the textbox, in the sheet or a userform. Are you using the control from the Control Toolbox menu. Are there any macros you are using. Mangesh "Marlis" wrote in message ... I have created a text box, but when I type in something, and hit enter, I get the error message "REFERENCE NOT VALID". Please help. Thank you |
#10
|
|||
|
|||
I have two dropdown lists. They work fine. I don't have a pivot table. Even
when I delete the text box and go to VB, the code is still there?? It does the same thing in another sheet. Thanks "Mangesh Yadav" wrote: What else do you have in your spreadsheet. Do you get the same behaviour in a new file if you repeat the same steps. Do you have a pivot table in the file which gives you the error. Mangesh "Marlis" wrote in message ... No missing tag. "Mangesh Yadav" wrote: Hi, No, not all should be checked. My only question was: If any of the current checked ones have a MISSING tag along, if so uncheck the box, otherwise let it be. Mangesh "Marlis" wrote in message ... This probably sounds like a dumb question, but should all of them be checked? Only the first five are. It only does it with the text box. Thanks "Mangesh Yadav" wrote: just a wild guess. Please go to the VBE and check Tools References. Check if there are any missing links. If yes, uncheck the ones which have missing. Do you get the same behaviour for any other control. Mangesh "Marlis" wrote in message ... I used the control toolbox to create the textbox in Excel. No macros. Thanks "Mangesh Yadav" wrote: We require some more details. Where have you created the textbox, in the sheet or a userform. Are you using the control from the Control Toolbox menu. Are there any macros you are using. Mangesh "Marlis" wrote in message ... I have created a text box, but when I type in something, and hit enter, I get the error message "REFERENCE NOT VALID". Please help. Thank you |
#11
|
|||
|
|||
When you delete a control, its code is not deleted, but what code are you
talking about. Do you have some code...? Mangesh "Marlis" wrote in message ... I have two dropdown lists. They work fine. I don't have a pivot table. Even when I delete the text box and go to VB, the code is still there?? It does the same thing in another sheet. Thanks "Mangesh Yadav" wrote: What else do you have in your spreadsheet. Do you get the same behaviour in a new file if you repeat the same steps. Do you have a pivot table in the file which gives you the error. Mangesh "Marlis" wrote in message ... No missing tag. "Mangesh Yadav" wrote: Hi, No, not all should be checked. My only question was: If any of the current checked ones have a MISSING tag along, if so uncheck the box, otherwise let it be. Mangesh "Marlis" wrote in message ... This probably sounds like a dumb question, but should all of them be checked? Only the first five are. It only does it with the text box. Thanks "Mangesh Yadav" wrote: just a wild guess. Please go to the VBE and check Tools References. Check if there are any missing links. If yes, uncheck the ones which have missing. Do you get the same behaviour for any other control. Mangesh "Marlis" wrote in message ... I used the control toolbox to create the textbox in Excel. No macros. Thanks "Mangesh Yadav" wrote: We require some more details. Where have you created the textbox, in the sheet or a userform. Are you using the control from the Control Toolbox menu. Are there any macros you are using. Mangesh "Marlis" wrote in message ... I have created a text box, but when I type in something, and hit enter, I get the error message "REFERENCE NOT VALID". Please help. Thank you |
#12
|
|||
|
|||
Private Sub TextBox1_DblClick(ByVal Cancel As MSForms.ReturnBoolean)
TextBox1.Value = TextBox1.Value + 1 End Sub That's the code I was given to increase number by one when I double click the box. "Mangesh Yadav" wrote: When you delete a control, its code is not deleted, but what code are you talking about. Do you have some code...? Mangesh "Marlis" wrote in message ... I have two dropdown lists. They work fine. I don't have a pivot table. Even when I delete the text box and go to VB, the code is still there?? It does the same thing in another sheet. Thanks "Mangesh Yadav" wrote: What else do you have in your spreadsheet. Do you get the same behaviour in a new file if you repeat the same steps. Do you have a pivot table in the file which gives you the error. Mangesh "Marlis" wrote in message ... No missing tag. "Mangesh Yadav" wrote: Hi, No, not all should be checked. My only question was: If any of the current checked ones have a MISSING tag along, if so uncheck the box, otherwise let it be. Mangesh "Marlis" wrote in message ... This probably sounds like a dumb question, but should all of them be checked? Only the first five are. It only does it with the text box. Thanks "Mangesh Yadav" wrote: just a wild guess. Please go to the VBE and check Tools References. Check if there are any missing links. If yes, uncheck the ones which have missing. Do you get the same behaviour for any other control. Mangesh "Marlis" wrote in message ... I used the control toolbox to create the textbox in Excel. No macros. Thanks "Mangesh Yadav" wrote: We require some more details. Where have you created the textbox, in the sheet or a userform. Are you using the control from the Control Toolbox menu. Are there any macros you are using. Mangesh "Marlis" wrote in message ... I have created a text box, but when I type in something, and hit enter, I get the error message "REFERENCE NOT VALID". Please help. Thank you |
#13
|
|||
|
|||
Your code works fine with me. What is it that you enter. Also can you exit
by pressing enter. I have to click outside to exit. Mangesh "Marlis" wrote in message ... Private Sub TextBox1_DblClick(ByVal Cancel As MSForms.ReturnBoolean) TextBox1.Value = TextBox1.Value + 1 End Sub That's the code I was given to increase number by one when I double click the box. "Mangesh Yadav" wrote: When you delete a control, its code is not deleted, but what code are you talking about. Do you have some code...? Mangesh "Marlis" wrote in message ... I have two dropdown lists. They work fine. I don't have a pivot table. Even when I delete the text box and go to VB, the code is still there?? It does the same thing in another sheet. Thanks "Mangesh Yadav" wrote: What else do you have in your spreadsheet. Do you get the same behaviour in a new file if you repeat the same steps. Do you have a pivot table in the file which gives you the error. Mangesh "Marlis" wrote in message ... No missing tag. "Mangesh Yadav" wrote: Hi, No, not all should be checked. My only question was: If any of the current checked ones have a MISSING tag along, if so uncheck the box, otherwise let it be. Mangesh "Marlis" wrote in message ... This probably sounds like a dumb question, but should all of them be checked? Only the first five are. It only does it with the text box. Thanks "Mangesh Yadav" wrote: just a wild guess. Please go to the VBE and check Tools References. Check if there are any missing links. If yes, uncheck the ones which have missing. Do you get the same behaviour for any other control. Mangesh "Marlis" wrote in message ... I used the control toolbox to create the textbox in Excel. No macros. Thanks "Mangesh Yadav" wrote: We require some more details. Where have you created the textbox, in the sheet or a userform. Are you using the control from the Control Toolbox menu. Are there any macros you are using. Mangesh "Marlis" wrote in message ... I have created a text box, but when I type in something, and hit enter, I get the error message "REFERENCE NOT VALID". Please help. Thank you |
#14
|
|||
|
|||
I enter the number 100.
My steps to put the box on my sheet: View-toolbars--controlbox--I then choose the textbox, I put it on the sheet,right click the box, and hit view code. I paste that code in, then return to the sheet. When I double click,it gives me "format picture" By the way...thank you for your patience. "Mangesh Yadav" wrote: Your code works fine with me. What is it that you enter. Also can you exit by pressing enter. I have to click outside to exit. Mangesh "Marlis" wrote in message ... Private Sub TextBox1_DblClick(ByVal Cancel As MSForms.ReturnBoolean) TextBox1.Value = TextBox1.Value + 1 End Sub That's the code I was given to increase number by one when I double click the box. "Mangesh Yadav" wrote: When you delete a control, its code is not deleted, but what code are you talking about. Do you have some code...? Mangesh "Marlis" wrote in message ... I have two dropdown lists. They work fine. I don't have a pivot table. Even when I delete the text box and go to VB, the code is still there?? It does the same thing in another sheet. Thanks "Mangesh Yadav" wrote: What else do you have in your spreadsheet. Do you get the same behaviour in a new file if you repeat the same steps. Do you have a pivot table in the file which gives you the error. Mangesh "Marlis" wrote in message ... No missing tag. "Mangesh Yadav" wrote: Hi, No, not all should be checked. My only question was: If any of the current checked ones have a MISSING tag along, if so uncheck the box, otherwise let it be. Mangesh "Marlis" wrote in message ... This probably sounds like a dumb question, but should all of them be checked? Only the first five are. It only does it with the text box. Thanks "Mangesh Yadav" wrote: just a wild guess. Please go to the VBE and check Tools References. Check if there are any missing links. If yes, uncheck the ones which have missing. Do you get the same behaviour for any other control. Mangesh "Marlis" wrote in message ... I used the control toolbox to create the textbox in Excel. No macros. Thanks "Mangesh Yadav" wrote: We require some more details. Where have you created the textbox, in the sheet or a userform. Are you using the control from the Control Toolbox menu. Are there any macros you are using. Mangesh "Marlis" wrote in message ... I have created a text box, but when I type in something, and hit enter, I get the error message "REFERENCE NOT VALID". Please help. Thank you |
#16
|
|||
|
|||
|
#17
|
|||
|
|||
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count Intervals of Filtered TEXT values in Column and Return Count across a Row | Excel Worksheet Functions | |||
Text Wrapping | Excel Discussion (Misc queries) | |||
Formulas dealing with text data | Excel Worksheet Functions | |||
Sort or Filter option? | Excel Worksheet Functions | |||
Read Text File into Excel Using VBA | Excel Discussion (Misc queries) |