Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.07 seconds.

  1. Edit code from specific cell to a range of cells, run time erro type mismatch

    Evening,

    I currently have the working code supplied below in use,

    This is how it works.
    I complete each cell with values in row 7 & i see cell B7 10th character change to red & also the value...
  2. Replies
    2
    Views
    118

    Re: Clear cell contents THEN close userform

    Thanks very much
  3. Replies
    2
    Views
    118

    Clear cell contents THEN close userform

    Afternoon.
    I have a worksheet called HONDA SHEET which has a drop down list in cell A2
    When i make a selection from the list my userform called HondaSoldItems is shown & values etc shown.

    Now...
  4. Re: Advice for existing code where todays month is entered to a cell

    Thanks,
    I get the impression you are not very happy ?

    Reading your post question i thought i answered it to what i thought you had asked me.
  5. Re: Advice for existing code where todays month is entered to a cell

    On the worksheets i have income and expenses values.
    At the end of the month i press a transfer button which collects the values from the cells which are at the bottom of each income / expense...
  6. Re: Advice for existing code where todays month is entered to a cell

    Hi,
    Looking at it most is styling.

    I also use it for Current Month, Ucase & Year.
  7. Re: Advice for existing code where todays month is entered to a cell

    Hi,
    At the end of the month i need to transfer the value from certain cells to my summary sheet,this is done with the transfer button.
    So then if i go look at the summary sheet i can see,
    Income...
  8. Re: Advice for existing code where todays month is entered to a cell

    Hi,
    Can you advise what or how that will work.
    Ive now changed it but it still shows September.
  9. Advice for existing code where todays month is entered to a cell

    Morning,

    I am currently using this code supplied below but i overlooked something when i was applying the code etc.

    The code takes the current month and enters it into cell B1 on several...
  10. Re: Deleting row changes font color advice please

    Thanks very much works fine
  11. Deleting row changes font color advice please

    Hi,
    I am using this working code shown below,
    It works like this.
    I complete each cell in my new row.
    In cell B7 i enter 17 characters,the 10th character is shown in a red font.
    Cell E has a...
  12. Re: If Then code advice please for existing working code

    Thanks that worked.
  13. Re: If Then code advice please for existing working code

    Trying to get this to work but keep getting End If Without Block If


    Private Sub Worksheet_Change(ByVal Target As Range) Dim c As Range

    On Error GoTo AllowEvents

    ...
  14. Re: Recorded macro placed in code shows not supported

    Many thanks & have a nice day.

    works fine.
  15. Recorded macro placed in code shows not supported

    Hi,
    I have the following working code in use.


    Private Sub Worksheet_Activate() Range("A3") = UCase(Format(Now, "mmmm"))
    Range("D3") = Year(Now)
    Range("A1:E3").HorizontalAlignment =...
  16. Re: Advice for existing working code on userform

    Thanks very much
  17. Advice for existing working code on userform

    Hi,
    I believe the code supplied below is what you require.
    I have a worksheet database where i send out parcels to customers & once parcel is received i like to make a note of the date on my...
  18. If Then code advice please for existing working code

    Evening,

    I am using the code shown below.
    I need to add a small piece of come to it if you can advise please.

    Basically you type a value in cell B7 & a date is also then entered into cell E7...
  19. Replies
    6
    Views
    80

    Re: Font ColorIndex Advice Please

    Ok all done.
    I used .

    Thanks very much.
  20. Replies
    6
    Views
    80

    Re: Font ColorIndex Advice Please

    Can you show me as I keep getting invalid qualifier message
  21. Replies
    6
    Views
    80

    Re: Font ColorIndex Advice Please

    Hi,
    How should it look when I place it into the code supplied.

    Thanks
  22. Replies
    6
    Views
    80

    Font ColorIndex Advice Please

    Hi,

    Below is a section of my working code.
    When it runs the year is entered into cell E7
    I just need to add to the existing code that when the entered year is placed in E7 it needs to be Red.
    ...
  23. Replies
    43
    Views
    643

    Re: Insert new row & apply Ucase

    Thanks for the effort & time to do this.
    Im going to leave the sheet as it is where the 10th character changes red & the date then put into cell E7
  24. Replies
    43
    Views
    643

    Re: Insert new row & apply Ucase

    trunten
    I see now it has.
    I see the ucase work & the 10th character change to red.

    Can you look at the file you have and see why the year isnt then put in cell E7 and the character has changed...
  25. Replies
    43
    Views
    643

    Re: Insert new row & apply Ucase

    With regards that file is the code you show already applied to it ?
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4