dcsimg

Search:

Type: Posts; User: vbfbryce

Page 1 of 13 1 2 3 4

Search: Search took 0.76 seconds.

  1. Replies
    8
    Views
    280

    Re: Stop apostrophe from becoming text

    Wasn't trying to heckle you, thought maybe it was different in a different version of Excel.

    :)
  2. Replies
    8
    Views
    280

    Re: Stop apostrophe from becoming text

    Pete,

    What do you mean you can't join strings with &?

    I have Jon in B1, and car in C1, and this gives me Jon's car in D1:


    Sub makeFormula()
    Dim ws As Worksheet
    Dim rng As Range
  3. Re: Unprotect ActiveX combobox on an Excel worksheet

    I don't think a cell's contents can be updated on a protected sheet using those arguments. "UserInterfaceOnly" protects the "interface" but not macros. Why don't you turn the protection off via...
  4. Replies
    6
    Views
    682

    Re: Vlookyp and paste special

    Something like this:


    Sub getVal()
    Dim wb As Workbook
    Dim wsC As Worksheet
    Dim wsD As Worksheet
    Dim lr As Long
    Dim J As Long
    Dim found As Boolean
  5. Replies
    10
    Views
    728

    Re: Set Outlook Out-of-office programatically

    How do you want this to be triggered? Click a button and choose the OoO pattern? Starting, or exiting Outlook? Other?
  6. Replies
    8
    Views
    599

    Re: option boxes and general buttons

    Make sure the MultiLine property of your text box is set to true, then:


    If Len(TextBox1.Text) = 0 Then
    TextBox1.Text = "something" 'change to your text to add
    Else
    ...
  7. Thread: Macro Newbie

    by vbfbryce
    Replies
    5
    Views
    534

    Re: Macro Newbie

    Sample attached, with code I posted earlier.
  8. Replies
    5
    Views
    513

    Re: Error message 400

    You're getting that because the Copy and Paste areas aren't then same size. The copy area is entire columns, yet the paste area starts in row 18, so not an entire column. i'd suggest finding the...
  9. Thread: Macro Newbie

    by vbfbryce
    Replies
    5
    Views
    534

    Re: Macro Newbie

    I have various dates from D1 down to Dxx. I have other dates in columns F - I. In both cases, there is no header for the column(s).


    Sub matchDates()
    Dim ws As Worksheet
    Dim lrD As...
  10. Replies
    18
    Views
    1,104

    MsOf10 Re: Send table on email

    Range("a1:d20").Copy ' change range to suit

    You would qualify this, something like:


    wsSummary.Range("a1:d20").Copy ' change range to suit

    You'd need to set wsSummary first.
  11. Re: Access AA coliumn in another worksheet(Excel 2016)?

    Explain a little more exactly what you're trying to do, please.
  12. Replies
    7
    Views
    1,020

    MsOf13 Re: [EXCEL VBA] Break links

    Good point. I tested with only one hyperlink on the sheet.
  13. Replies
    7
    Views
    1,020

    MsOf13 Re: [EXCEL VBA] Break links

    I tested it. Works like a charm!
  14. Replies
    7
    Views
    1,020

    MsOf13 Re: [EXCEL VBA] Break links

    I believe it would work if you used Defined Names rather than a Cell Reference.
  15. Re: Problem trying to assign values to chart FullSeriesCollection

    I think ChartValues is a string array, and needs to be converted to numbers. I would suggest creating a second array of some numeric type and populating it from ChartValues, then use the 2nd array...
  16. MsOf365 Re: [Outlook] Is there a place in the outlook ui that is easily writable and visible?

    Are you trying to automatically create a reply, based on (and at the time of) receiving emails from these specific recipients, with the added text somewhere in the reply? Or are you wanting to...
  17. Re: Read 'Pass' or 'Fail' Status from multiple html files placed under a folder using

    Can you zip and attach an example of the file?
  18. Re: [Vb.net] Why this code not runnig? [Excel]

    Works fine for me. As long as the first character in B7 is a number. What do you have in B7?

    Also, like SH says, there's no point in multiplying by 1. Are you thinking that will make it an...
  19. MsOf365 Re: Excel 365: Missing Microsoft MonthView control 6.0 (SP4)

    Maybe check this out:

    https://social.technet.microsoft.com/Forums/Azure/en-US/db3b4dff-aad7-4d88-87cc-8f3f117be550/microsoft-windows-common-controls-60-for-office-2016
  20. Replies
    9
    Views
    936

    Re: Linking powerpoint text to a VSTO add in

    As Pete states, if you're using the code within Powerpoint, no additional references are required. If you're doing it within Visual Studio, then, yes, you'd need a reference to the Powerpoint object...
  21. Replies
    9
    Views
    936

    Re: Linking powerpoint text to a VSTO add in

    Still don't understand exactly, but maybe something like this:


    Sub getText()
    Dim activeShape As Shape
    Dim shp As Shape
    Dim pres As Presentation
    Dim sld As Slide

    ...
  22. Replies
    9
    Views
    936

    Re: Linking powerpoint text to a VSTO add in

    I'm confused. If you're selecting the text manually, why do you need code to copy it? Please explain more fully.
  23. Re: Problem with userform after upgrade to Win 10

    Thanks for the direction. I found out one is a Listview4, will need to check the other.

    They are indeed two different versions.

    Thanks!
  24. [RESOLVED] Problem with userform after upgrade to Win 10

    Our shop floor computers all had Windows 7 up until a couple of weeks ago. Some have been upgraded to Win 10. They all have Excel 2010.

    I developed an app that employs a userform with only three...
  25. Replies
    3
    Views
    564

    MsOf365 Re: PowerPoint 365 - Resize Text Box

    Mine is named "txtTop" and this is the code I'm using to change the values on each slide:


    Sub formatTB()
    Dim pres As Presentation
    Dim sld As Slide
    Dim shp As Shape
    Dim J As...
  26. Replies
    3
    Views
    564

    MsOf365 Re: PowerPoint 365 - Resize Text Box

    How are you defining "the text box in question?" Does the "one at the top" have a consistent name on each slide?
  27. Replies
    1
    Views
    469

    Re: [RESOLVED] VBA error - please help

    You never set rng1
  28. MsOf365 Re: Excel 365: How to pick every name once only from a list?

    I'd suggest using the Advanced Filter on this page:

    http://www.excelhowto.com/5-ways-to-get-unique-values-in-excel/
  29. Replies
    18
    Views
    2,037

    Re: Macro for tab wise invoice creation

    It's hard to read error messages in images. What is the error, and on which line?
  30. Re: How can I detect and change the system audio level in Excel?

    Can you show what you have that's working to that point so far?
  31. Re: Outlook VBA to change mailto based on subject

    Pete,

    I tested your code, and get an error here:


    r.Remove

    I think it was "operation not allowed."

    This link:
  32. Re: Outlook VBA to change mailto based on subject

    Pete,

    I tested your code, and get an error here:


    r.Remove

    I think it was "operation not allowed."

    This link:
  33. Re: how to draw lines and more from drawing tools in excel using vb.net

    Are you asking if you can draw a diagonal line from "right to left?" If so, yes, that's what I demonstrated in #10. Change the from and the to points according to your needs.
  34. Re: how to draw lines and more from drawing tools in excel using vb.net

    Here's an example drawing two lines, the second of which has arrowheads. Both lines are drawn from the upper left of one cell to the upper left of another. These starting and ending points can be...
  35. Re: How to use Macro in Personal workbook with two different workbook

    Can you show us the code you're currently trying to use?
  36. Re: How to disable left mouse button drag and drop of a worksheet

    I would think if you protect the workbook, and choose only "Structure," you'd accomplish what you're after. It will not allow you to move sheets, but will still allow the sheets themselves to be...
  37. MsOf07 Re: Sort comma separated numbers and normal numbers together

    We really need to better understand your rule set before we can help.

    For example, do you want to use only the first digit when you have something like 7,8.9?

    To JDC's question, does 7,8,9 come...
  38. MsOf07 Re: Sort comma separated numbers and normal numbers together

    what if you have one cell with 7,8,9 and another with 79.

    Which comes first?
  39. Replies
    46
    Views
    2,900

    Re: Worksheet Name Right 4 characters

    I've asked previously, and will ask again, since you've mentioned several times that you've changes pieces of the code. Can you post it as it now stands in it's entirety? I can't follow when you...
  40. Replies
    46
    Views
    2,900

    Re: Worksheet Name Right 4 characters

    So what IS the value of prod & "Report" when you get the error?
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Featured


Click Here to Expand Forum to Full Width