Excel 2003 - Techist - Tech Forum

Go Back   Techist - Tech Forum > Computer Software > Microsoft Windows and Software
Click Here to Login
Closed Thread
 
Thread Tools Display Modes
 
Old 02-01-2005, 03:45 AM   #1 (permalink)
Newb Techie
 
Join Date: Jan 2005
Posts: 16
Send a message via Yahoo to olorin
Question Excel 2003

I may be a tad behind the times, but I have just installed Microsoft Office Professional 2003, after using Lotus Suite for the last 8 years.
I am well versed in writing macros and using LotusScript in Lotus Apps, but this Visual Basic in Excel is a different kettle of fish.
For instance, does anyone know how to call up a "getnumber" dialog box in Excel as one can in Lotus? I'm sure there's an easy answer but I can't for the life of me work it out.
I have only had Excel for 3 days, so there's plenty of time to get to know it yet, but I wouldnt mind knowing how to call up a list of macros and scripts available.
Any help would be appreciated.
P.S
I have ordered a couple of reference books on Visual Basic, but I am impatient, and you guys an gals are generally quick with responses.
__________________

olorin is offline  
Old 02-01-2005, 06:35 AM   #2 (permalink)
Techie Beyond Description
 
Osiris's Avatar
 
Join Date: Jan 2005
Location: Kentucky
Posts: 36,817
Send a message via ICQ to Osiris Send a message via AIM to Osiris Send a message via MSN to Osiris Send a message via Yahoo to Osiris
Default

Whats the problem you are try to solve or make to get a number?
__________________

__________________
Osiris is offline  
Old 02-01-2005, 11:04 AM   #3 (permalink)
Newb Techie
 
Join Date: Jan 2005
Posts: 16
Send a message via Yahoo to olorin
Default

I wish to attatch a script to a button inside a userform (which I have already made), so that when clicked, a message box appears with a field to enter a number, and when the user clicks OK the number is placed in the workbook in a particular cell.
Thanx for ur time
olorin is offline  
Old 02-08-2005, 07:39 PM   #4 (permalink)
Newb Techie
 
Join Date: Jan 2005
Posts: 16
Send a message via Yahoo to olorin
Default

Thanx for ALL ur replies and follow-ups. I managed to sort it out from the books I bought.
olorin is offline  
Closed Thread

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off




Copyright 2002- Social Knowledge, LLC All Rights Reserved.

All times are GMT -5. The time now is 02:49 PM.


Powered by vBulletin® Version 3.8.8 Beta 1
Copyright ©2000 - 2017, vBulletin Solutions, Inc.