Search:

Type: Posts; User: vbfbryce

Page 1 of 13 1 2 3 4

Search: Search took 0.11 seconds; generated 5 minute(s) ago.

  1. Re: Drawing shapes on "canvas" and persisting when closing app

    Thanks, Kevin!
  2. Re: Drawing shapes on "canvas" and persisting when closing app

    I'm 3/4 of the way through both links, and again thanks! Looks like exactly what I need!
  3. Re: Drawing shapes on "canvas" and persisting when closing app

    Thank you, will do!
  4. Drawing shapes on "canvas" and persisting when closing app

    Hi guys and gals. I'm going to work on an app for landscape design, so the user will click on a shape in the "toolbox" and drop it onto their canvas, being able to move and size it appropriately. ...
  5. Replies
    2
    Views
    825

    MsOf13 Re: Deleting certain rows using VBA

    For multiple filter criteria, something like:


    Sub afilter()
    Dim ws As Worksheet
    Dim rng As Range

    Set ws = ActiveSheet
    Set rng = ws.Range("a1:a9") 'change to your range
  6. Replies
    6
    Views
    1,910

    Re: Visual Basic Private Sub won't run

    Private Sub Worksheet_Change(ByVal Target As Range)
    If Not Intersect(Target, Range("a:a")) Is Nothing Then
    MsgBox "do something based on change in column A"
    ElseIf Not...
  7. Replies
    6
    Views
    1,910

    Re: Visual Basic Private Sub won't run

    As Pete says, a description of what you're trying to accomplish would be helpful.

    Having said that, if you fix the errors he mentions, I don't think you'd like the results. If you change a value...
  8. Re: MsOF16 Powerpoint: Bold + text shadow

    You're very welcome, glad it worked for you!
  9. Re: MsOF16 Powerpoint: Bold + text shadow

    Assuming you've already inserted a module, this would make whatever text is selected BOLD and SHADOWED:


    Sub makeBold()
    ActiveWindow.Selection.TextRange.Font.Bold = msoTrue
    ...
  10. Re: Excel - Change borders/gridlines back to defailt

    Assuming you have cells on that sheet with the border style you want, you could copy that to the range from which you unlist the table, like:


    rng1.Borders(xlEdgeRight).LineStyle =...
  11. Replies
    2
    Views
    1,266

    Re: Excel VBA 7.1 - runtime error 6 overflow

    What type is AC, and what are the values of LBED and WBED when the error happens?
  12. Replies
    1
    Views
    600

    Re: Vba run time error 53

    Check to see if "sOutputFileName" contains a valid file name. It's telling you that file doesn't exist when you try to open it to read.
  13. Re: I've no idea what I'm doing, could someone please help?

    Do you have a reference to "ArduinoExcel?"
  14. Replies
    2
    Views
    2,918

    Re: Data Type Mismatch

    What does strSQL contain when you run it?
  15. Replies
    8
    Views
    1,774

    Re: Stop apostrophe from becoming text

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

    :)
  16. Replies
    8
    Views
    1,774

    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
  17. 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...
  18. Replies
    6
    Views
    2,160

    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
  19. Replies
    10
    Views
    6,919

    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?
  20. Replies
    8
    Views
    946

    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
    ...
  21. Thread: Macro Newbie

    by vbfbryce
    Replies
    5
    Views
    695

    Re: Macro Newbie

    Sample attached, with code I posted earlier.
  22. Replies
    5
    Views
    1,476

    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...
  23. Thread: Macro Newbie

    by vbfbryce
    Replies
    5
    Views
    695

    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...
  24. Replies
    18
    Views
    3,597

    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.
  25. Re: Access AA coliumn in another worksheet(Excel 2016)?

    Explain a little more exactly what you're trying to do, please.
  26. Replies
    7
    Views
    2,359

    MsOf13 Re: [EXCEL VBA] Break links

    Good point. I tested with only one hyperlink on the sheet.
  27. Replies
    7
    Views
    2,359

    MsOf13 Re: [EXCEL VBA] Break links

    I tested it. Works like a charm!
  28. Replies
    7
    Views
    2,359

    MsOf13 Re: [EXCEL VBA] Break links

    I believe it would work if you used Defined Names rather than a Cell Reference.
  29. 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...
  30. 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...
  31. 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?
  32. Replies
    6
    Views
    1,444

    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...
  33. 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
  34. Replies
    9
    Views
    1,513

    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...
  35. Replies
    9
    Views
    1,513

    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

    ...
  36. Replies
    9
    Views
    1,513

    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.
  37. 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!
  38. [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...
  39. Replies
    3
    Views
    1,516

    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...
  40. Replies
    3
    Views
    1,516

    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?
Results 1 to 40 of 499
Page 1 of 13 1 2 3 4



Click Here to Expand Forum to Full Width