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.
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.
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
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.
Posts
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
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?