Search:

Type: Posts; User: lezawang; Keyword(s):

Page 1 of 6 1 2 3 4

Search: Search took 0.06 seconds.

  1. Replies
    1
    Views
    42

    recording marco timing

    Hi
    Can I change the timing in recording macro. For example I want to copy a cell and then paste it to another location after 3 seconds. Can I do that by Recording Macro. Not written a code. Thank...
  2. Replies
    1
    Views
    50

    new module for recording macros

    Hi
    I inserted a module and wrote a macro there. Then went to excel and recorded a macro. I went back to VB editor and found that excel inserted a new module and put recorded macros in that module...
  3. Replies
    3
    Views
    35

    Re: active cell in selected cells

    Thank you very much.
  4. Replies
    3
    Views
    35

    active cell in selected cells

    Hi
    I selected cells A1:A20. They are all selected and the active one now is A1. I can make A2 as an active one without losing the selection by pressing Tab key, I can make cell A10 as an active one...
  5. Replies
    2
    Views
    70

    custom formatting

    Hi
    I want to write a custom formatting code to do the following:


    <tbody>
    user enter
    excel shows


    1
  6. adding $ before a number vs selecting currency/accounting format

    Hi
    Is there any difference/problem if I add $ before a number manually, I mean I type $ then the number after vs selecting Number formatting-->currency or Accounting? Thank you.
  7. Replies
    4
    Views
    124

    Re: upto 1, 2, 3 digits

    Thanks all for your help.

    1.211 1 1/5 1 4/19 1 23/109

    So 1 1/5 (5 is 1 digit that is called upto 1)

    1 4/19 (19 is 2 digit that is why it is called upto 2)

    1 23/109 (109 is 3 that is...
  8. Replies
    4
    Views
    124

    upto 1, 2, 3 digits

    Hi
    I went to Format Cell -> Fraction and I saw the first 3 options.

    1) Upto 1 digit
    2) Upto 2 digits
    3) upto 3 digits

    I entered in a cell this value 1.1 and formatted 3 cells as above, so i...
  9. Replies
    1
    Views
    45

    Recording a Summation Macro

    Hi

    I am reading a course outline and it says students will learn

    Recording a Summation Macro
    Recording Consolidations
    Recording Divisional Macros

    My question, what does...
  10. copy a column - paste as a row with comma separated

    Hi
    I have these names in one column. I want to copy them and paste them a text file. but the way I want to paste them in text file is like this
    ...
  11. Replies
    3
    Views
    97

    Re: Date format in excel

    Thank you very much. The format of the 3rd row is Date, the format of the 5th row is Custom. But my question, why custom was selected as dd-mmm-yy.
    Also still not sure why the 3rd one accept as a...
  12. Replies
    3
    Views
    97

    Date format in excel

    Hi
    My computer date/clock is DD-MM-YYYY. So I tried to enter the following. I understand all except 3rd and the 5th (the last) rows. Why Excel accepted

    yyyy-m-dd as a date and why accepted sept...
  13. Replies
    1
    Views
    74

    Date format in excel

    Hi
    My computer date/clock is DD-MM-YYYY. So I tried to enter the following. I understand all except 3rd and the 5th (the last) rows. Why Excel accepted

    yyyy-m-dd as a date and why accepted sept...
  14. asking user to enter numbers and msg out these numbers -vba

    Hi
    With a help from Fluff, I created the code below. It is asking user to enter 3 numbers then the code will msg out these 3 numbers. I want to improve this code. I do not want to limit user to...
  15. Replies
    5
    Views
    220

    Re: when filter function will be available?

    Thank you all. Now I did it in my way, using absolute reference and then autofill. I also created a new column using ISNA() function and I got False and True. Now I want to change the last column to...
  16. Replies
    5
    Views
    220

    Re: when filter function will be available?

    Another question, I did use exactly the same formula he used but did not work. When I typed the formula in the cell B2 and press enter. It only applied to the first cell (it did not copy over like...
  17. Replies
    5
    Views
    220

    when filter function will be available?

    Hi
    I just watched a video and ExcelIsFun author said Filter() not not available now. He manged to do a lot of stuff without using array function anymore. That is a big change.

    My second...
  18. Replies
    6
    Views
    341

    Re: is this left() VBA or Worksheet function

    Thank you all. The F1 trick is amazing. Thanks all once again
  19. Replies
    6
    Views
    341

    is this left() VBA or Worksheet function

    Hi
    I am reading about dealing with text in VBA (the link below) and I see code similar to the one below. My question, this left() function is VBA native or Worksheet function. My guess is VBA...
  20. Re: asking user to enter 10 numbers then find the max

    Works very nicely. Thank you very much. I appreciate it
  21. asking user to enter 10 numbers then find the max

    Hi

    I want to write a code (for learning purpose) asking user to enter 10 numbers or whatever user going to enter then the code will find the max number from these number and print a message saying...
  22. Replies
    9
    Views
    287

    Re: using variables from other macro

    Thanks all again for the help. I did run the code above but msgbox was empty in both cases. I entered x=10 and y="hello". Thanks a lot
  23. Replies
    9
    Views
    287

    Re: using variables from other macro

    Thanks all for the help. I did the Global x and y but did not work.
    each macro would start with a line ------- and end with a line ----
    when I start typing "Global x As Integer" and press enter...
  24. Replies
    1
    Views
    756

    mail merge change the format of the date

    Hi I am not sure if this excel or word issue. I have a column in excel which has dates formatted as below. When I mail merge to word, I loss the format and the date will convert to something like...
  25. Replies
    9
    Views
    287

    using variables from other macro

    Hi
    How can I make the second marco print out the values from the first macro?
    for example I want to use the second marco to msg out x and y which are variable in first macro. Thank you so much.

    ...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4