| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Information results on user form?
Hi I have made a spreadsheet to calculate golf scores and do
countbacks, the spreadsheet works fine but not knowing much about vba programming I am wondering if a user form can be used to enter imformation on to the spreadsheet but also show on the user form the results of what would be entered ie: If a Golfer had 4 strokes on hole 1 and if entered would receive 2 stableford points, can I get the user form to show this before I commit the score to the spreadsheet? Thank You EPJ |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Information results on user form?
On Mar 23, 9:22 pm, wrote:
Hi I have made a spreadsheet to calculate golf scores and do countbacks, the spreadsheet works fine but not knowing much about vba programming I am wondering if a user form can be used to enter imformation on to the spreadsheet but also show on the user form the results of what would be entered ie: If a Golfer had 4 strokes on hole 1 and if entered would receive 2 stableford points, can I get the user form to show this before I commit the score to the spreadsheet? Thank You EPJ Yes you can, I suggest reading these: http://www.mrexcel.com/tip019.shtml http://www.mrexcel.com/tip009.shtml http://www.mrexcel.com/td0071.html and then doing a few google group searches for stuff you don't understand yet. Good luck! Chris |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Information results on user form?
EPJ,
I am just wondering why you need a userform? It might well be easier to use a sheet as your interface, in which case you can use Excel's maths and logic capability inside the sheet. Once you are happy with what is entered, copy the entered score into your master sheet. -- Robin Hammond www.enhanceddatasystems.com "cht13er" wrote in message ... On Mar 23, 9:22 pm, wrote: Hi I have made a spreadsheet to calculate golf scores and do countbacks, the spreadsheet works fine but not knowing much about vba programming I am wondering if a user form can be used to enter imformation on to the spreadsheet but also show on the user form the results of what would be entered ie: If a Golfer had 4 strokes on hole 1 and if entered would receive 2 stableford points, can I get the user form to show this before I commit the score to the spreadsheet? Thank You EPJ Yes you can, I suggest reading these: http://www.mrexcel.com/tip019.shtml http://www.mrexcel.com/tip009.shtml http://www.mrexcel.com/td0071.html and then doing a few google group searches for stuff you don't understand yet. Good luck! Chris |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| User Form Information | Excel Discussion (Misc queries) | |||
| Transferring information from one user form to another | Excel Programming | |||
| How do I put my information form Excel into a Word Merge Form? | Excel Discussion (Misc queries) | |||
| Use a text box to calculate and show results in a user form | Excel Discussion (Misc queries) | |||
| Pulling information from a worksheet into a user form | Excel Programming | |||
Linear Mode
