Consulting

Results 1 to 14 of 14

Thread: Designing applications in visual basic??

  1. #1

    Designing applications in visual basic??

    Hi,

    First of all, I'll apologise in advance for my complete inexperience in anything other than excel



    Essentially, I've created a handfull of fairly sucessful (In my workplace) userform based applications using excel. Id really like to move more towards stand-alone applications.
    From what i can gether, that would mean using Visual basic. With a bit of "youtubing", I see that its very similar, just without excel in the background, holding all the data/formulas etc.

    Unless i want to design a calculator, youtube isnt too useful for my query, so I thought I'd use what has been my most valuable tool with my excel queries, which is obviously you loveley people.

    1. Where does the background work happen with applications created in visual basic.
    2. Where are the best resources (tutorials/example projects etc).
    3. Am i barking up the wrong tree - is visual basic, the right tool for the job. I'm basically wanting to create applications that give users the ability to track (amongst other things), real time stats for kpi's etc.
    4. ..
    5. ..
    6. I could go on for ever

  2. #2
    Bump

  3. #3
    Moderator VBAX Wizard SamT's Avatar
    Joined
    Oct 2006
    Location
    Near Columbia
    Posts
    6,846
    Location
    userform based applications using excel
    I assume you mean that you are using a worksheet as a UserForm, because MS UserForms are VBA based Forms. Right click on a tab and select "View Code" to open the VBA Editor. Typ in the Codepage "UserForm," place the cursor inside that word and press F1. Browse around the Help file that opens looking at "Objects" in the Contents section.

    To answer your questions:

    1. In VBA Code Pages
    2. VBAExpress
    3. Nope. Right Tree


    Besides browsing this forum, "Project Assistance," You might pick up some ideas from

    Finding a date without a search

    help with complicated formula

    Trying to copy paste and delete a row

    Pulling custom footer from another sheet, to only appear on *final* page

    The basic steps are to gather every form, paper and electronic, now in use and make a list of all Data Points on them. Then:

    1. Organize your Databases
    2. Design your Reports
    3. Design your DataEntry Forms.
    4. Write the Database code
    5. Write the Userforms code
    6. Write the Reports code


    Note that as the project progresses, you will be modifying the results of previous steps, but if you follow the (badly stated) rules in the links, you will minimize those modifications.
    Please take the time to read the Forum FAQ

  4. #4
    SamT, firstly, based purely on the effort you put in to your assistance, I doth my cap to you


    I think an example of what I've done previously, will better explain.

    I've had to re-jig it to take away company stuff etc, but should work fine and be resonably self explanitory.

    I Love excel and what magic it can perform, but it scares the people I need to be able to use it for me to progress further.

    What I'd really like, is to be able to design "applications" so, that, the "excel" stuff is hidden, so all thats left is the Userform.

    The example I've included is a fairly basic example of some of the projects, that I've not been able to finish off, due to the fear that users ( and users managers) have with excel and therefore the very slow progress of my projects that are designed with the idea of improving effinciency etc.

    Did I mean Visual Studio??
    Attached Files Attached Files

  5. #5
    Moderator VBAX Wizard SamT's Avatar
    Joined
    Oct 2006
    Location
    Near Columbia
    Posts
    6,846
    Location
    That's a wonderful App. Password protected so nobody can see what's happening.
    Please take the time to read the Forum FAQ

  6. #6

    *Update without password*

    Thats mostly to hide my shoddy vba...

    I suppose I cant really expect to upload something thats partly (largely..) thanks to people like your good self and protect the vba..

    Heres an unprotected version
    Attached Files Attached Files
    Last edited by gringo287; 08-17-2013 at 03:11 PM. Reason: I'm an idiot

  7. #7
    BoardCoder
    Licensed Coder
    VBAX Expert mark007's Avatar
    Joined
    May 2004
    Location
    Leeds, UK
    Posts
    619
    Location
    There are things you can do to hide Excel. However, a better approach is probably to look at writing your own "applications" using VB.Net.

    Take a look at: http://www.microsoft.com/visualstudi...indows-desktop

    It's free and fully operational for creating windows apps.

    VB.Net is different to VBA but miles better. Once you've used .Net, VBA will feel clumsy.

    A few examples:

    - No need to use set
    - Fully object oriented
    - You can initialise variables when you declare them
    - Auto-indent
    - Auto complete of e.g. End If
    - Incredible intellisense

    It will take a little getting used to but will be worth it once you do.

    :-)
    "Computers are useless. They can only give you answers." - Pablo Picasso
    Mark Rowlinson FIA | The Code Net | Professional Office Developers Association

  8. #8
    Thanks Mark007, that sounds interesting.

    Am I being silly though, as the link takes me to this, which is a 30 day trial

    Click image for larger version. 

Name:	Mark007.JPG 
Views:	252 
Size:	87.2 KB 
ID:	10463

  9. #9
    Moderator VBAX Wizard SamT's Avatar
    Joined
    Oct 2006
    Location
    Near Columbia
    Posts
    6,846
    Location
    I mostly looked at UserForm2 and I think yu would be better served by putting the phone scripts in Worksheets.

    Set the cdButtons Tag to the worksheet name, then when the commandbutton is clicked Activate the sheet, set the UF.Visible = False, Call a Sub that embeds a button on the sheet in Cell A1 that shows the UF and calls another a sub that removes the embedded button. Just keep passing the Sheets name (cmdButton Tag) to each sub,

    Using TextBoxes to hold the phone scripts makes it impossible to edit the scripts and impossible to even see most of them in Design mode.

    Unfortunately, between editing your workbook and converting it to xls format, something vital was lost, so I don't know if the forms and code will be avbailable in this attachment. The Phone Script sheets I made are there. I did format the Priority Sports sheet as I thought looked good.
    Attached Files Attached Files
    Please take the time to read the Forum FAQ

  10. #10
    Thank's SamT,

    Something did go wrong there I think.

    This was only an example of what I'm wanting to achieve without relying on excel.

    I've been swatting up on vb.Net with some YouTube vids and it does indeed seem perfect for what I'd like to move towards. It has opened up some more questions though.

    1/ is there a free version for me to play with, like what Mark007 referred to, as the link takes me to the trial version of the full thing
    2/ Do you have to use Access when dealing with tables etc. I've not used access for around 7 years..
    3/ If the answer to (2) is yes, does access have to be available on the end users pc (my workplace doesn't have access to... Access). If the answer to (2) is No, can you just use excel.

    I fully appreciate that these may sound like very basic questions, that I should already know, Considering what I've managed to achieve in excel, but I still class myself as a complete noob , that just happens to a be tenacious son of a gun, so I've basically not slept for around two years while I've been concentrating solely on excel... Before then, the only time I spent on pc's was playing around on photoshop.

  11. #11
    Moderator VBAX Wizard SamT's Avatar
    Joined
    Oct 2006
    Location
    Near Columbia
    Posts
    6,846
    Location
    Tenacious? Yes.

    I spent the first year of Excel analyzing the MSO 97 Object Model and recreating it as an Excel table(s).

    Regardless of the programming language, the seven, (including gathering all the forms,) steps of designing an App are the same as I listed very briefly above.

    A more detailed version of the steps is in one of the links I gave. I left out the gathering of forms, because the OP had already done that.

    Free VB.Net IDE's:
    http://www.microsoft.com/visualstudi...press-products
    http://www.icsharpcode.net/opensource/sd/
    http://www.ilovefreesoftware.com/26/...harp-free.html
    http://pao-ide.info/
    Ask.com Search

    More about VB.net: https://en.wikipedia.org/wiki/Visual_Basic_.NET

    Buy it: http://www.ebay.com/bhp/visual-studio-net
    Please take the time to read the Forum FAQ

  12. #12
    BoardCoder
    Licensed Coder VBAX Expert mark007's Avatar
    Joined
    May 2004
    Location
    Leeds, UK
    Posts
    619
    Location
    The link is to a free version. You have to register within 30 days but registration is free! :-)

    When you talk about dealing with tables, I assume what you are referring to is a database. In which case the answer is no, you can use whatever database engine you want to use. This could be Access, XML, SQL server (express is free from microsoft too!), MySQL, text files etc.

    Access is not a bad choice to use as the database jet engine is generally installed on windows PCs (or can be redistributed if not). End users don't need to actually have access.

    You could use Excel but users would then need Excel installed and this would be a clunky way of doing it.
    "Computers are useless. They can only give you answers." - Pablo Picasso
    Mark Rowlinson FIA | The Code Net | Professional Office Developers Association

  13. #13
    Thank's for your responses Mark007 and SamT, I'll dig in to these tmo :-)

  14. #14
    Sorry for the delay, been a bit hectic.

    Ive checked out the links and have been having a good swatting up session. It looks perfect. I'll be back soon with plenty more questions

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •