Thread: Userforms
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Desperate Desperate is offline
external usenet poster
 
Posts: 20
Default Userforms

Hello! I am new to this newsgroup so, I hope I do this right. O.k, my
question is:
I have a userform in Excel, and the textbox, once a value is entered, goes
to a cell in the sheet, and in the sheet, there are vlookup functions to
lookup the value of that same cell. textbox is going to cell B1, and B1 is a
lookup value for other functions in the sheet. This is what happens: once I
use my userform and enter a value in B1, the vlookups come back as "#N/A",
but if I enter a value without using the userform, the vlookups work. B1 is
formatted to a general number, if that helps. Help!?