Always I am indebted.
From the text box in the user form created by the macro, enter the set value
I'm trying to get it
"Object variable or with block variable not set"
I get an error and it doesn't work.
I think the path is correct ...
(Object name of user form. Object name of text box. Value)
The code description is a standard module.
I would appreciate it if anyone could teach me.
Function getTasks_1 () As String () Dim task As String Dim taskDetails As String Dim workHour As String Dim progress As String task = UserForm1.TextBox_Work content ①.Value taskDetails = UserForm1.TextBox_Details of work contents ①.Value workHour = UserForm1.TextBox_Man-hours ①.Value progress = UserForm1.TextBox_Progress ①.Value Dim tasks (3) As String tasks (0) = task tasks (1) = taskDetails tasks (2) = workHour tasks (3) = progress getTasks_1 = tasks End Function
Answer # 1
It was my careless mistake, and I am very sorry for those who cooperated!
Thank you, meg_, for your inconvenience through the comments!
- macro file excel when i open it on a mac, it says "this file is corrupted and cannot be opened" on windows
- c ++ - even if i put a value in the array obtained by the data () method of vector, size is not updated
- java - cannot get value from postgresql
- serial port - communication data cannot be obtained when using multiple hardware serial communication with arduino mega
- is it possible to send the value that can be obtained with vuejs in the form of laravel? (without axios)
- excel vba [i want to auto filter by the value of the list box]
- i want to get the value of the first row in the column obtained by the excel vba large function
- excel vba cell time value to list box
- c# cannot get the value of textbox (mvvm)
- vba - cannot store the total value extracted by the auto filter in a variable
- php - laravel: value obtained by pluck cannot be obtained by foreach
- only the last value can be obtained after foreach processing of laravel array
- excel vba scraping cannot get the class under the class without id or name tag
- macros created in excel on vba mac cannot be executed normally on windows
- ruby - display the value obtained via the intermediate table
- jquery - cannot get and reflect the value corresponding to the tr row of the external json read table
- python 3x - some emojis cannot be obtained by scraping using python
- vba - how to get an excel workbook that opens automatically after downloading automatically
- repeat for vba lines
- to find values from a range with excel vba
- vba - i want to copy the last line and paste it to the last line +1
- vba sheet 1 a7, c7, sheet 2 a2 "2020" 03 "01" numerical value is added and displayed in the cell as "20
- vba error occurs after the second time
- cannot read file with vba adodbstream
- vba - draw a ruled line only for the table below
- vba - i want to create a macro that does not post data under certain conditions, but the conditions do not work
- vba - an error occurs when searching for a numerical value using find and moving the corresponding cell