Submitted by Mike Moore on January 26, 2007 - 9:19pm Excel Questions
Categories:
(I apologize if this is a duplicate post. I've setup a
dedicated GMail account for my Project and tried
mailing from that address, and it bounced.)
Anyone out there work with Excel?
Visual Basic Applications?
UserForms?
I'm using Excel 2000.
I'm in the process of creating a front end
for Spreadsheet Data Input.
I do a lot of looking for answers in the
forums, specifically:
and
but, they can be a pain, if you're not
sure how to phrase your search or
which forum to look in.
And even if you do post a question,
you don't always get an answer or
a useful answer.
So, I'm trying to broaden my pool.
I'm fairly knowledgeable. So, if you
have questions - ask. I'll do the
best I can to help. And if you think
you can help, let me know.
Every so often I get stuck and it
would really help when timeliness
is important.
Thanx.
Also wanted to pass on a useful
Excel Addon (FREE):
ASAP Utilities
http://www.asap-utilities.com/
Is there anyone who'd be interested
in this project?
I can post a prototype when I'm done -
which I expect to be within the next
week or so.
Mike Moore
Current Vista
El Centro de la Raza
Seattle, WA
Take care.
P.S. Prototype attached.
P.P.S. Additional Info:
Code for Userforms and Macros here has been acquired and modified from various sources around the web. |
||
Website: | ||
The Main Userform Menus: |
http://www.fontstuff.com/downloads/index.htm | |
(VBA04-UserForms.xls) | ||
Table of Contents: | http://www.mrexcel.com/board2/viewtopic.php?t=157547&postdays=0&postorder=asc&start=10&sid=e639a2ad5f67ac8e9f686e6589dd2d56 | |
Zack Baresse - off of the Mr Excel User Board search on his name (or his nick: firefytr) and (or) "Table of Contents" | http://www.mrexcel.com/board2/viewtopic.php?t=105761&highlight=createtoc | |
Sheetnames - Listbox | http://www.mrexcel.com/board2/viewtopic.php?t=254481&highlight= | |
My query on the Mr Excel User Board - search for user: elcentro3m | ||
Open a Userform on Cell Click | http://www.mrexcel.com/archive2/8800/9831.htm | |
This is the code used on cell "A1" of a sheet to open the Data Entry Form |
Attachment | Size |
---|---|
Excel_Menu_Example.xls | 207.5 KB |
Example_List_Box_Range_Menu.xls | 62.5 KB |