i have a task of producing a spreadsheet that asks questions and takes figures then displays them as a report.
e.g how much is your energy bill? the user types a figure, its calculated in a formula, and the results displayed in a report.
I need it set out so it looks professional and user friendly. Has anyone got any examples of well laid out user friendly colourful spreadsheets?
Would appriciate it if some one could help me.
Thanks a great deal
hi, i would like to know the site or resource for mastering Loops like DO loops and other loops with examples.if any body knows some sites do list here.
Hello everybody,
Can anybody upload the
2500 Excel VBA Examples, if you have.
Hi,
I am looking for a good website specially a video tutorial that shows you how to create dashboards or charts. I am looking for similar website like http://www.datapigtechnologies.com/
this is very good website for those of you who need to do some fancy staff with excel. Any help will be appriciated. Thanks.
Hi to everyone.
I'm returning to work and need practice on Excel 2003 pivot charts.
i've downloaded Bill's 2007 book and found the download for earlier version pivot chart learning; however, i can't find downloads for the earlier book.
Does anyone have the link to download Excel 2003 pivot chart examples from Bill's first book?
Thank you so much,
Randa
I have created quite a few mini excel apps/ tools to do various tasks eg querying and displaying text files, mainly for my own use and for a couple of colleagues.
While generally they do the job, they all look a bit naff and amateur.
Does anyone know of some good sample excel apps on the web that I could get some inspiration from? I'm not looking to do anything too fancy just make my spreadsheets look a little more professional.
Thanks
Hi, I need help in writing functions maybe for example to find if named sheet exist with x name...etc if not do this else that...or
to see if col has dates...
My actual question would be to learn how to write this kind of function.
Thanks in advance.
Pedie
Pls let me know as to where i can download a pdf version of this book
I have followed the instuctions below from the "Holy Macros! It's 2,500 VBA Examples" on cd. I inserted the code for the userform module as instructed. The Toolbox and Userform1 comes up. I right click and select view code, then paste the userform code. I paste the standard module code into a standard module also. I close VBA and all I get when I run the macro is " Runtime error '424'". When I select debug "frmSelect.Show" in module1 is highlighted.
I'm new to programing what am I leaving out. Are further steps needed that are missing from the instructions. Everthing that I have on the instructions are below
Text-Index: 152901
Topic: Dialog Boxes and UserForms
Subject: Select worksheet with UserForm-ComboBox.
Excel-Version: >= 5.0
Question: Selection of sheet with UserForm-ComboBox. Macro executed with CTRL-A
Answer: Insert the following code in the appropriate modules.
'Place the code below into the userform module
Private Sub cboSheets_Change()
Worksheets(cboSheets.Value).Select
Unload Me
End Sub
Private Sub UserForm_Initialize()
Dim wks As Worksheet
For Each wks In ThisWorkbook.Worksheets
cboSheets.AddItem wks.Name
Next wks
End Sub
'Place the code below into the standard module
Sub DialogCalling()
frmSelect.Show
End Sub
