|
|
| Author |
Message |
Goraz
RealPoor Guru
Joined: 11 Oct 2002
Posts: 3736
Location: Philadelphia
|
 Posted: 09/15/05 - 10:43 Post subject: Who is VERY good with Excel? HEPL
|
|
|
I'm looking to figure out how to use active X controls "Via Tools > View > Control Toolbar
Basically i'm trying to add text boxes in my spreadsheets where you can enter a value and once entered, will lookup that value in a range of selected cells of data and return them.
I know the VLOOKUP function but I do not know how to apply it with Text boxes.
hepl plz
|
|
|
Back to top
|
|
|
|
 |
Paden
RealPoor Master of Posts
Joined: 23 Oct 2002
Posts: 9362
Location: North CAROLINA!
|
|
Posted: 09/15/05 - 10:48 Post subject:
|
|
|
|
stop trying to get people to do your job!
|
|
|
Back to top
|
|
|
|
|
killswitch
Luke Warm
Joined: 09 Jun 2003
Posts: 325
|
|
Posted: 09/15/05 - 13:57 Post subject:
|
|
|
|
VLOOKUP is a spreadsheet function, it will only work in Cells. Anything having to do with manipulating text boxes with events requires the use of VBA. Do yourself a favor and go to Barnes & Nobles and pick up a book on Excel VBA.
|
|
|
Back to top
|
|
|
|
|
IceIsFun
Toomuchtimeonhands
Joined: 11 Oct 2002
Posts: 781
Location: Orlando, FL
|
|
Posted: 09/15/05 - 14:05 Post subject:
|
|
|
Link the value (Properties->Values) of your text box to a cell. Lookup operations can then be performed on that cell, which will be whatever you type into your text-box. Alternatively, create your form in such a way that the data entry elements are actual cells (hint: merge cells that are not used as entry, display or labels).
Btw, it may not be as easy, but MS Access is incredibly more powerful for creating interactive reports/forms. Have fun!
|
|
|
Back to top
|
|
|
|
|
khrath
Guest
|
|
Posted: 09/15/05 - 14:09 Post subject:
|
|
|
| IceIsFun wrote: | Link the value (Properties->Values) of your text box to a cell. Lookup operations can then be performed on that cell, which will be whatever you type into your text-box. Alternatively, create your form in such a way that the data entry elements are actual cells (hint: merge cells that are not used as entry, display or labels).
Btw, it may not be as easy, but MS Access is incredibly more powerful for creating interactive reports/forms. Have fun! |
wtf did you just say, you better stop talking that shit n***a!
|
|
|
Back to top
|
|
|
|
|
Ishmael
RealPoor Guru
Joined: 03 Jun 2005
Posts: 4446
Location: The US of A
|
|
Posted: 09/15/05 - 15:43 Post subject:
|
|
|
| khrath wrote: | | IceIsFun wrote: | Link the value (Properties->Values) of your text box to a cell. Lookup operations can then be performed on that cell, which will be whatever you type into your text-box. Alternatively, create your form in such a way that the data entry elements are actual cells (hint: merge cells that are not used as entry, display or labels).
Btw, it may not be as easy, but MS Access is incredibly more powerful for creating interactive reports/forms. Have fun! |
wtf did you just say, you better stop talking that shit n***a! |
Lol irl.
P.S. I have no idea what he said. 
f**k Excel!
|
|
|
Back to top
|
|
|
|
|
Samiam
Luke Warm
Joined: 18 Jan 2003
Posts: 319
|
|
Posted: 09/15/05 - 16:02 Post subject:
|
|
|
|
lmao. great thread.
|
|
|
Back to top
|
|
|
|
|
Maldek
RealPoor Guru
Joined: 16 Oct 2002
Posts: 2089
|
|
Posted: 09/15/05 - 16:40 Post subject:
|
|
|
print it out and duct tape an abacus to it ya heard
|
|
|
Back to top
|
|
|
|
|
Goraz
RealPoor Guru
Joined: 11 Oct 2002
Posts: 3736
Location: Philadelphia
|
|
Posted: 09/15/05 - 17:09 Post subject:
|
|
|
| IceIsFun wrote: |
Btw, it may not be as easy, but MS Access is incredibly more powerful for creating interactive reports/forms. Have fun! |
I know and im waiting for IT to install it on my system but they are f*****g slow jackasses.
|
|
|
Back to top
|
|
|
|
|
Obmar
RealPoor Sensei
Joined: 22 Oct 2002
Posts: 1934
|
|
Posted: 09/15/05 - 21:05 Post subject:
|
|
|
|
any effort to have excele do this for you is a waste of time when Access (or any real dbase) can do it mo betta
|
|
|
Back to top
|
|
|
|
|
Nahualli
RealPoor Master of Posts
Joined: 11 Oct 2002
Posts: 8461
|
|
Posted: 09/15/05 - 21:27 Post subject:
|
|
|
| Obmar wrote: | | any effort to have excele do this for you is a waste of time when Access (or any real dbase) can do it mo betta |
Wow!!
Did you just call Access a "real database"?
-Nah-
|
|
|
Back to top
|
|
|
|
|
|
|
