Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.07 seconds.

  1. Replies
    0
    Views
    6

    Advice to merge two codes

    Hi,

    I wish to run these two codes when i open the worksheet MC LIST.



    Private Sub Worksheet_Activate() Range("A6").Select
    Range("A4:G4").Font.Size = 24
    Range("A6:G40").Font.Size...
  2. Replies
    0
    Views
    13

    Code for character allowance in cell

    Morning,

    I am looking for a code which will show a msgbox to advise me the character count in the active cell is anything but 17

    Some info for you.
    Worksheet is called MC LIST
    The code will...
  3. Replies
    2
    Views
    73

    Re: Could you check my code please.

    Now all sorted.

    >Resize needed to be 1
  4. Replies
    2
    Views
    73

    Re: Could you check my code please.

    Hi,
    Still trying to get this right,

    I have changed the middle part to the below.



    If CDate(strDate) > CDate("05/04/2019") Then
    sh.Cells(fRow, 4).Resize(, 2).Value =...
  5. Replies
    2
    Views
    73

    Could you check my code please.

    This is the whole code from my worksheet,



    When i click the Transfer button it should copy & paste like shown below.

    Copy G INCOME cell D31 & paste to G SUMMARY cell D9

    Copy G INCOME cell...
  6. Replies
    4
    Views
    78

    Re: Expand on current code in use

    Works a treat thanks DanteAmor
  7. Replies
    4
    Views
    72

    Re: Calculation just doesnt add up

    I knew that but been a long day BODMAS

    Thanks
  8. Replies
    4
    Views
    72

    Calculation just doesnt add up

    Hi,
    I am trying to write a small basic code for fuel allowance of 45p per mile.

    Currently i use this which works fine & correct.


    =E18*0.45


    But i now wish to add the cell value at E34
  9. Replies
    4
    Views
    78

    Expand on current code in use

    Hi,

    Supplied is the current code in use.
    I wish to expand the code to apply a number in the corresponding cell in column E
    Target cells are currently in column D "name of shop" & now wish to...
  10. Replies
    4
    Views
    123

    Re: VLOOKUP based on drop down list

    Hi,
    This gives me a blank cell but is it correct & ok to use ?


    =IFERROR(VLOOKUP(B5,$N$4:$Q$21,2,0),"")
  11. Replies
    4
    Views
    123

    Re: VLOOKUP based on drop down list

    Hi,
    Yes that works.

    Before i select from the drop down list colmns C,D & E show #N/A until i make a drop down selection.
    Need to be able to show the cell is blank without the #N/A

    Im not sure...
  12. Replies
    4
    Views
    123

    VLOOKUP based on drop down list

    Hi,
    I need to select a value from my drop down list and the code will look at three values in a database then put them in three next to where the drop down list is.
    Here is the info for you.
    ...
  13. Replies
    6
    Views
    98

    Re: Code lags when run

    Hi,

    Anybody have a few minutes spare to check this workbook or see if they can replicate my lag issue.
    Its a very small workbook but i seem to have the issue on the worksheet called G INCOME
    ...
  14. Replies
    2
    Views
    72

    Macro button on desktop

    Is it possible to have a button on the desktop which would open a msgbox & then two options.

    Selecting one option to open this workbook selecting the other option would open a different workbook.
  15. Replies
    6
    Views
    98

    Re: Code lags when run

    Hi,
    Yes i do.
    There are other worksheets in this workbook with code etc.

    What i have just done for the last hour etc is to move say 5 worksheets from this workbook & have them in there own...
  16. Replies
    6
    Views
    98

    Re: Code lags when run

    Hi,
    Just above my pc clock whilst i am waiting for excel to do its job i see some text flashing like,
    Calculating 2 processors ?
  17. Replies
    6
    Views
    98

    Code lags when run

    Hi,
    On my worksheet called G EXPENSES i have the following code in use but when i leave the cell i dont see the name appear straight away but more like 2 seconds later.


    Private Sub...
  18. Replies
    7
    Views
    123

    Re: Merge two Worksheet_Change codes

    No problem i started like that.
    Thanks the code works & welcome to the forum
  19. Replies
    7
    Views
    123

    Re: Merge two Worksheet_Change codes

    Ok,
    I will check.

    On a side not when you put code here you need to put it in between tags.
    Look on the toolbar where you type your message and you will see this logo #

    Click on it and you...
  20. Replies
    7
    Views
    123

    Re: Merge two Worksheet_Change codes

    Hi,
    Where did the range A1:B20 come from ?
  21. Replies
    7
    Views
    123

    Merge two Worksheet_Change codes

    Hi,
    I habe these two codes.


    Private Sub Worksheet_Change(ByVal Target As Range)If Intersect(Target, Range("J1:M3")) Is Nothing Then Exit Sub
    Application.EnableEvents = False
    Target.Value =...
  22. Replies
    2
    Views
    60

    Re: Could you advise on this code please

    Morning,
    So looking at the sheet this was taken from columns 1 & 7 are dates where all the other columns are text.

    Thanks
  23. Replies
    2
    Views
    60

    Could you advise on this code please

    Morning,
    I see this code a few times on my worksheets but dont know what its actually doing,please can you advise.


    Private Sub Worksheet_Change(ByVal Target As Range) With Target
    If...
  24. Replies
    10
    Views
    182

    Re: Search column & place names in list box

    I didnt even try that piece of code.
    works great,many thanks friend
  25. Replies
    10
    Views
    182

    Re: Search column & place names in list box

    Many thanks,thats sorted A-Z great.

    Last thing.
    Im trying to close the userform after i made a selection in the listbox.
    Currently i type my known info in the textbox & see the results appear in...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4