+ Reply to Thread
Results 1 to 8 of 8

Moving Shape Down on Laptop Monitor Unsuccessful

  1. #1
    Registered User
    Join Date
    02-24-2022
    Location
    Ozaukee County, Wisconsin, USA
    MS-Off Ver
    Office 365 and Office 2013
    Posts
    19

    Question Moving Shape Down on Laptop Monitor Unsuccessful

    Dear Forum,

    I am trying to move a shape down one row on a worksheet. When I use the following code to do so on an external monitor that is attached to my laptop, the process works perfectly. If, however, I move the Excel workbook to my laptop's screen and try to perform the same operation, it errors out almost every time. Also, if I close the workbook, disconnect the external monitor, and re-open the workbook on my laptop, the same problem occurs.

    By "erroring out", I mean that the shape is not placed down to the new row correctly, and code following the placement fails to execute. The shape appears halfway or so down to the new row, and all of the other dimensions seem to be set correctly. It's just not "down" in the right place.

    Does anyone have any insight on this? I'm running Office 365 on a Windows 10 HP EliteBook laptop.

    Please Login or Register  to view this content.
    Brian
    Last edited by wiitguru; 03-17-2022 at 01:41 PM. Reason: Missed one line of code.

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,425

    Re: Moving Shape Down on Laptop Monitor Unsuccessful

    Fast answers need visual help. Please read the yellow banner at the top of this page on how to attach a file.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Registered User
    Join Date
    02-24-2022
    Location
    Ozaukee County, Wisconsin, USA
    MS-Off Ver
    Office 365 and Office 2013
    Posts
    19

    Re: Moving Shape Down on Laptop Monitor Unsuccessful

    TMS,

    Sure, no problem. Please see attached example workbook. Oddly, I tried the sample workbook on my laptop, and it seems to be working. For the moment, anyways.

    Brian
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    02-24-2022
    Location
    Ozaukee County, Wisconsin, USA
    MS-Off Ver
    Office 365 and Office 2013
    Posts
    19

    Re: Moving Shape Down on Laptop Monitor Unsuccessful

    I have performed some more tests with the original code and the example code, both in the original workbook and in its own workbook. Here are my results. Also, I've attached an updated workbook that allows the user to move the shape up or down, for easier testing..

    Still having the same problem.

    Anyways, here are my results.

    shape-work-conditions.jpg

    Brian
    Attached Files Attached Files

  5. #5
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,425

    Re: Moving Shape Down on Laptop Monitor Unsuccessful

    I'm afraid that I'm not going to be able to help you. Your code works perfectly on my laptop. The shape moves up and down, and resizes to the dimensions of the cell. It also shows a message, as expected, if you try to move up above row 1.

    It's a quite old Toshiba Satellite with Windows 10 and Office 365.

    I can only assume that it is an issue with the combination of the laptop itself and the original workbook.

  6. #6
    Registered User
    Join Date
    02-24-2022
    Location
    Ozaukee County, Wisconsin, USA
    MS-Off Ver
    Office 365 and Office 2013
    Posts
    19

    Re: Moving Shape Down on Laptop Monitor Unsuccessful

    TMS,

    Well, thanks for checking for me. I hope that some other people can check and post their results for me as well.

    Thanks!

    Brian

  7. #7
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,425

    Re: Moving Shape Down on Laptop Monitor Unsuccessful

    You're welcome. Thanks for the rep.

  8. #8
    Registered User
    Join Date
    02-24-2022
    Location
    Ozaukee County, Wisconsin, USA
    MS-Off Ver
    Office 365 and Office 2013
    Posts
    19

    Re: Moving Shape Down on Laptop Monitor Unsuccessful

    No problem!

    Brian

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 1
    Last Post: 10-17-2017, 10:36 PM
  2. Moving Byproduct of View>New Window to Second Monitor
    By sbeatty in forum Excel General
    Replies: 3
    Last Post: 03-19-2017, 07:53 AM
  3. Moving Shape with Cursor
    By sswcharlie in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-16-2015, 05:06 PM
  4. Move Office 365 from Old Laptop to New laptop
    By claudiahacks in forum Office 365
    Replies: 0
    Last Post: 09-09-2013, 04:33 AM
  5. shape moving with cells
    By gingko in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-11-2013, 05:48 PM
  6. moving duplicate shape
    By kramer in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-13-2007, 03:14 PM
  7. [SOLVED] shape of cursor does not change over command button on second monitor
    By Herb Meier in forum Excel General
    Replies: 2
    Last Post: 06-02-2005, 02:05 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1