LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default VBA for excel

Hi all.

I am very new to VBA but have been using basic Macros for some time.

I have created a button on the front page of my document. I have been able
to get this to display a dialogue box which I created - this askes questions
of the user and the idea is that they fill it in. The information sort is
generally of a text nature (this is more about making it look nice than
anthing else) I have one drop down list with 3 predefined choices and one
set of either Yes or No Options, the rest are all just text.

I want to be able to have each of the boxes deposit the information to a
cell on a background sheet. I then want to be able to use this information
for other calculations within my sheet.

I designed the dialogue box on the Dialog1 sheet but want the information to
go to a sheet I have called "General Information"

Please please can someone help me.

SpottyTash


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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



All times are GMT +1. The time now is 12:23 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"