Search:

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

Page 1 of 2 1 2

Search: Search took 0.01 seconds.

  1. Power Query connection to files on SharePoint - users cannot connect

    Hello, I am using Office 2016 and Windows10. I have 4 files all in a SP doc library - 1 main file with connections to 3 Excel files in the same library. I originally set up the connection using...
  2. Re: Load UserForm InkPicture with Ink saved in Excel worksheet

    ok, thank you for your responses. I'll keep trying and if i find the solution, I'll post what I discover.
  3. Re: Load UserForm InkPicture with Ink saved in Excel worksheet

    sorry about that, that was my lack of knowledge. I was able to progress further. I'm having trouble getting the Ink back into the InkPicture. I can see that it's saving the .gif file in the same...
  4. Re: Load UserForm InkPicture with Ink saved in Excel worksheet

    Yes, I believe I do. I pasted it in Modules > Module1
  5. Re: Load UserForm InkPicture with Ink saved in Excel worksheet

    Hello, I apologize for the long delay. I've been trying a few different things today. First, I changed all InkEdit1 to InkPicture1. This caused an error (Object doesn't support this property or...
  6. Re: Load UserForm InkPicture with Ink saved in Excel worksheet

    Thank you so much for your response! I see where you're going and it seems like it'll work great. I'm having trouble with the line that says "PasteToControl InkEdit1.hWnd". I'm getting an error:...
  7. Load UserForm InkPicture with Ink saved in Excel worksheet

    Hello,
    I have struck out all day trying to find an answer to my problem. I would really appreciate any assistance that you can offer.
    I have a UserForm with an InkPicture that I am using for...
  8. Replies
    5
    Views
    551

    Re: email completed multipage userform

    Thank you SO much! You're awesome :)
  9. Replies
    5
    Views
    551

    Re: email completed multipage userform

    Thank you for your response. Great information to have. Do you know if it's possible to code it to automatically cycle thru every object on the userform and enter its value on the Temp sheet or do...
  10. Replies
    5
    Views
    551

    email completed multipage userform

    Hello,
    I have a 2 page multipage userform. I would like one user to fill out the fields on the first page, email the workbook containing the completed userform to a second user that will complete...
  11. Re: ActiveX ComboBox dropdown flashes, can't get list to appear

    oh boy. ActiveX problems might be the deal breaker for me. I don't have a great reason for not creating a UserForm. Part of it is my infant knowledge of UserForms, the bigger part was the...
  12. Re: ActiveX ComboBox dropdown flashes, can't get list to appear

    I can see this being a useful option, my hesitation is that I'm building a form in Excel (not using UserForm) so when things need to be hidden, there are quite a few ComboBoxes to hide, or to move if...
  13. ActiveX ComboBox dropdown flashes, can't get list to appear

    Hello,
    I've been having trouble with my ActiveX ComboBoxes on my excel spreadsheet. I am not using the ComboBox on a UserForm, it's just on my sheet. Here is the situation:

    I have a ComboBox...
  14. Replies
    2
    Views
    4,490

    Re: Formula to display column width in pixels

    Thank you for your response, Tubal. The formula gets into trouble when it uses "width" b/c you get a rounded number. I'll end up with an approximate pixel number but I'm really needing an exact...
  15. Replies
    2
    Views
    4,490

    Formula to display column width in pixels

    Hello,
    I would like to use a formula to have the column width in pixels displayed in the cell. I would like the formula to be dynamic so that as I change the column widths, the pixel number, as...
  16. Replies
    12
    Views
    6,773

    Re: PowerPoint: Trouble with calculated item

    well, it's been an interesting afternoon. I've been Googling, trying to figure out why I don't see 'Calculation Area' in the location you mention and I've come across some postings from people with...
  17. Replies
    12
    Views
    6,773

    Re: PowerPoint: Trouble with calculated item

    ok scottsen, I think I'm making progress, but adding some confusion. I played with things on my home computer on the weekend and I now understand where you're talking about when you say to enter the...
  18. Replies
    12
    Views
    6,773

    Re: PowerPoint: Trouble with calculated item

    OOOOOOHHHHHHHHHH, I get it now :grin: You enter the formulas in the same place where you import your dataset. You just pick an empty column, enter your formulas and away you go! I did some playing...
  19. Replies
    12
    Views
    6,773

    Re: PowerPoint: Trouble with calculated item

    I was digging into things last night, trying to figure out why I don't have the "Manage" option. I'm wondering if we're not using different versions of Excel/PowerPivot. I'm using 2010 and when I...
  20. Replies
    12
    Views
    6,773

    Re: PowerPoint: Trouble with calculated item

    Thank you for the responses! I shut down Excel and tried to create my Measures again. It worked this time. Thank you scottsen!

    PentaGalCXO, I have a question for you - I don't think I...
  21. Replies
    12
    Views
    6,773

    PowerPivot: Trouble with calculated item

    Hello,
    I'm using Excel 2010. I have been scouring Mr. Excel posts and all over the internet for answers on how to create a calculated item in PowerPivot. All the possible answers I've found want...
  22. Replies
    5
    Views
    370

    Re: vb to search for a range of numbers

    yep, that does the trick, thank you!
  23. Replies
    5
    Views
    370

    Re: vb to search for a range of numbers

    Thank you so much AnalyticsGuy7! Sorry for the long delay in response, I had to take my work with me for the extended long weekend and I didn't have internet access to respond. The code you...
  24. Replies
    5
    Views
    370

    vb to search for a range of numbers

    good afternoon,
    I'm trying to write some macro that will search my spreadsheet for a range of accounts, if it finds even just one number in that range it then does a bunch of steps, if it can't find...
  25. Replies
    2
    Views
    384

    Re: using Array in vba

    Ahhhhh, thank you Peter, this works perfectly. I had pulled out most of my hair already! Such a simple thing when you see the answer.

    have a great day!
Results 1 to 25 of 44
Page 1 of 2 1 2