The new forums will be named Coin Return (based on the most recent vote)! You can check on the status and timeline of the transition to the new forums here.
The Guiding Principles and New Rules document is now in effect.

Excel Help?

GuiberuGuiberu Registered User regular
edited July 2008 in Games and Technology
Folks,

I'm trying to build a special little something for a work related spreadsheet and need a hand.

I'm trying to create a "Chat Room" style tab with a text box and a Macro that send the text in the text box to an external spreadsheet that is then referenced in the Chat Room tab to display text from all users. Unfortunately you can't copy and paste text from a text box into a merged display box. Coupled with that I then need to figure out how to apply a scroll bar to display all text that's entered.

Any Ideas?

Guiberu on

Posts

  • FaceballMcDougalFaceballMcDougal Registered User regular
    edited July 2008
    Macros are simply VBA code except Excel does the coding for you. To do something like this you will have to know a lot more than how to create a macro.

    This is a really odd choice for Excel and I know it's a powerful program and all but you should probably examine other solutions.

    If someone at my job had this idea, even if the business could benefit from it, I would have to advise against using Excel. I would be the guy building it

    FaceballMcDougal on
    xbl/psn/steam: jabbertrack
  • ScooterScooter Registered User regular
    edited July 2008
    This sounds more like an H/A topic, but I have to agree that if I was making my own chat room program, excel would never enter my mind as the method to do it with.

    Scooter on
  • RUNN1NGMANRUNN1NGMAN Registered User regular
    edited July 2008
    Whatever it is you're trying to do, there's probably a hundred easier ways to do it than using Excel or building a macro.

    Rule of thumb--if you don't actually want to used Excel as a spreadsheet program, you probably shouldn't use Excel.

    If you want to set up some sort of "office chat room" there are programs that can do that.

    What would the purpose be of this text box and external spreadsheet--is it just so that people can leave comments?

    RUNN1NGMAN on
Sign In or Register to comment.