{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Úvod","InputBox","InputBox obdelník"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Úvod","index":0,"n_rows":28,"n_cols":8,"rows_kept":28,"cut":false,"hidden":false,"merged":[[1,2,1,9],[2,2,2,9],[12,2,13,6],[15,3,16,6],[16,7,16,9],[27,1,27,11]]}
[]
[null,null,"Jak na Excel "]
[null,null,"MUNI"]
[]
[]
[null,null,null,"Obsah cvičení"]
[null,null,null,null,"Input box"]
[]
[]
[]
[]
[]
[null,null,"Pavel Lasák"]
[]
[]
[null,null,null,"Lektor, expert na Microsoft Excel, držitel prestižního ocenění Microsoftu MVP v České republice"]
[null,null,null,null,null,null,null,5002722]
[]
[]
[]
[]
[null,null,null,"Další informace ke cvičení:"]
[null,null,null,null,"http://office.lasakovi.com/excel/vba-formulare/excel-inputbox-vstupni-box/"]
[]
[]
[]
[]
[null,"Copyright, Pavel Lasák 2017"]

{"sheet":"InputBox","index":1,"n_rows":43,"n_cols":2,"rows_kept":43,"cut":false,"hidden":false,"merged":[[0,0,0,6],[1,0,1,6],[42,0,42,6],[43,0,43,6],[15,0,15,6],[3,0,3,6],[4,0,4,6],[28,0,28,6],[41,0,41,6]]}
["InputBox - Excel VBA"]
[]
[]
["Syntaxe"]
["InputBox(Zpráva, Titulek_dialogu, Výchozí_hodnota, Posice_X , Posice_Y, Help, context) "]
[]
[null,"Zpráva - povinné - text zprávy zobrazení v dialogu"]
[null,"Titulek_dialogu - nepovinné - text v titulku dialogu"]
[null,"Výchozí_hodnota - nepovinné - pokud je požadavek na výchozí hodnotu"]
[null,"Posice_X - nepovinné - pozice okna x"]
[null,"Posice_Y - nepovinné - pozice okna y"]
[null,"Help - nepovinné - odkaz na soubor s nápovědou"]
[null,"context - nepovinné - Číslo tématu nápovědy ze souboru nápovědy - musí být zadán Help."]
[]
[]
["Zobraz číslo, které uživatel zadá"]
[]
[null,"Promena = InputBox(\"zadej číslo:\", \"Titulek_dialogu\", 10, 500, 400)"]
[null,"MsgBox (Promena)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Zobraz číslo, které uživatel zadá"]
["využít proměnné pro popis hodnot v inputBoxu"]
[]
[null,"Popis = \"Zadej číslo:\""]
[null,"Titulek_dialogu = \"Titulek input boxu\""]
[null,"Promena = InputBox(Popis, Titulek_dialogu, 10, 500, 400)"]
[null,"MsgBox (Promena)"]
[]
[]
[]
[]
[]
[]
[]
["http://JakNaExcel.cz"]

{"sheet":"InputBox obdelník","index":2,"n_rows":34,"n_cols":2,"rows_kept":34,"cut":false,"hidden":false,"merged":[[0,0,0,6],[1,0,1,6],[33,0,33,6],[34,0,34,6]]}
["InputBox - Excel VBA"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"ZpravaA = \"Zadejte stranu A\""]
[null,"ZpravaB = \"Zadejte stranu B\""]
[null,"Titulek_dialogu = \"Vstupní dialog pro vypočet obdelníku\""]
[null,"Vychozi_hodnota = 0"]
[null,"Posice_X = 100"]
[null,"Posice_Y = 200"]
[]
[null,"StranaA = InputBox(ZpravaA, Titulek_dialogu, Vychozi_hodnota, Posice_X, Posice_Y)"]
[null,"StranaB = InputBox(ZpravaB, Titulek_dialogu, Vychozi_hodnota, Posice_X, Posice_Y)"]
[]
[]
[]
[]
[null,"Plocha = StranaA * StranaB"]
[]
[null,"MsgBox (Plocha)"]
[]
[]
[]
[]
[]
[]
["http://JakNaExcel.cz"]