How to create UserForms using Office Scripts | Excel Off The Grid

แชร์
ฝัง
  • เผยแพร่เมื่อ 22 ธ.ค. 2024

ความคิดเห็น • 9

  • @BenLinfordUK
    @BenLinfordUK ปีที่แล้ว +2

    Great job Mark!

  • @micheltw
    @micheltw ปีที่แล้ว +1

    thank you for this neat demonstration Did you find this all by yourself?

    • @ExcelOffTheGrid
      @ExcelOffTheGrid  ปีที่แล้ว +3

      I think Jan Karel Pieterse probably created the first example of using a worksheet to collect user input.
      jkp-ads.com/Articles/Excel-office-script-examples.asp#Prompting_for_user_input
      I've just taken it to the next step by using Shapes and Ranges, plus I've used buttons to control them. In terms of the code and methods, I've created all of that myself.

  • @danielw9064
    @danielw9064 หลายเดือนก่อน

    how did you make it so the shapes were not selectable/moveable. Whenever i click on a shape it shows a line with dots around it to allow for resizing and moving. Is there a way to prevent that?

  • @IvanCortinas_ES
    @IvanCortinas_ES ปีที่แล้ว +2

    Is it possible to upload the file to the platform? I have some errors and I don't see the way to fix them. Thank you.😩

    • @ExcelOffTheGrid
      @ExcelOffTheGrid  ปีที่แล้ว +3

      I've added the download files to the blog post. If it's not working because I've done something wrong, just let me know.

  • @flexyourdata
    @flexyourdata 9 หลายเดือนก่อน +1

    lovely jubbly

    • @ExcelOffTheGrid
      @ExcelOffTheGrid  9 หลายเดือนก่อน

      With introduction of checkboxes, I suspect worksheet based will be the future.