Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |