• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. S

    Tables - Change Name from original given by Excel

    Hi It is not possible to give a new table a user selected name, but can be changed only afterwards. I would like to use vba to look at selected table, and change name to a specific cell value (name), say Tbl_sales (in say B14) That is once the table is selected then run the macro. Thanks...
  2. S

    Post messages between sheets on textboxes

    With a workbook that has several users simultaneously, not all in the same room etc., want to be able for each sheet user to message a master sheet user and in reverse as well, with info. Very similar to the sms messages on a smart phone, basically 2 columns with in and out comments. Is there...
  3. S

    Excel 2013 and Android

    Hi Just setting up a simple workbook with a sheet that records data. Will have a user form. Details from this sheet will be sent daily by email to the main workbook below. The main workbook is on a PC computer using Win10 and XL2013. The issue is that the company wants to use Android...
  4. S

    Excel2000 SendKeys

    Hi In attached WB there are 2 macros named testsendkeys () and testsendkeys1(). The first one works ok and places data into the Notebook. It uses a .exe file obtained from here: http://orlando.mvps.org/SendKeysMore.asp?IdC=OrlMoreWin2 Have tried to contact site but with no success. With the...
  5. S

    VBA Set Up Variable and loop

    Hi I am setting a variable etc. The loc1 is a dynamic named range, storing integers starting at G5 there is a changing total number of entries in it. Another Macro will have to get the value in each row and then use it in a subroutine Sub CheckingVariable Dim LastRow As Long Dim i As Long...
  6. S

    combine timeon and number of repeats

    Hello I have a macro that needs to be run every say 10 seconds and for a set number of times, say 5. I have tried to combine the two types of code, timeon and repeat codes. Not quite correct yet. Anyone able to assist. Run every 10 seconds for in this case 5 times "RefreshData" is the...
Back
Top