Ask Me Help Desk

Ask Me Help Desk (https://www.askmehelpdesk.com/forum.php)
-   Spreadsheets (https://www.askmehelpdesk.com/forumdisplay.php?f=395)
-   -   Excel help (https://www.askmehelpdesk.com/showthread.php?t=8616)

  • Mar 26, 2005, 08:19 PM
    thetachi464
    Excel help
    I am using excel to record some data and I have it setup to do some math based on the info that I put into certain cells. Now what I am wondering is am I able to setup the sheet so that it will prompt me for the 4 pieces of data that I want to enter and then place those in the proper cells and then go from there. I am pretty good with excel but I am not sure how this can be done or if it can be. If it can please someone help this is not a big deal but it would be nice to know how to do this.
  • Mar 27, 2005, 06:16 AM
    ScottGem
    Excel does support forms, so you could create a form and/or some coding to prompt you for the values to insert into the specified cells. What you should be looking at is getting into VBA (Visual Basic for Applications) which can automate Excel to a large extent.

  • All times are GMT -7. The time now is 04:49 PM.