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:

http://www.mrexcel.com

and

http://www.excelforum.com

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

 

 

 

AttachmentSize
Excel_Menu_Example.xls207.5 KB
Example_List_Box_Range_Menu.xls62.5 KB