Writing into random cell base on textbox values, Error if textbox have Multiple values only works with single value

[petroes]

i'm totally new with VBA and need your help, the problem is i want to select random cells in a given row, as you can see in the picture, the userform have ComboBox X = represent row, TextBox Y=Represent column and CommanButton "Input", i'm stuck with the error when i try to input multiple values separated with comma inside the textbox, as far it only works if the textbox contain a single values within, here is my code :

Private Sub cbInput_Click()

Dim x As Variant
Dim y As Variant

x = cmbBox_X.Value
y = txtBox_Y.Value

With Worksheets.Application.ActiveSheet
.Cells(x, y).Value = "check" '(error in here when i try with multiple values: runtime error ''13''; type mismatch)
End With

End Sub

 

[dmt32]

Hi,
welcome to forum

try

Private Sub cbInput_Click()
    
    Dim x As Variant
    Dim y() As String
    Dim i As Integer
    
    x = Val(cmbBox_X.Value)
    y = Split(txtBox_Y.Value, ",")

    For i = 0 To UBound(y)
        ActiveSheet.Cells(x, y(i)).Value = "check"
    Next
    
End Sub

Dave

 

[AlphaFrog]

Cross posted

Writing into random cell base on textbox values, Error if textbox have Multiple values [SOLVED]

i'm totally new with VBA and need your help, the problem is i want to select random cells in a given row, as you can see in picture below, the userform have ComboBox X = represent row, TextBox Y=Represent column and CommanButton "Input", i'm stuck with the error when i try to input multiple...

www.excelforum.com

A message to forum cross posters

 

[dmt32]

Cross posted

So annoying & I normally check before responding.

 

[petroes]

Cross posted

Writing into random cell base on textbox values, Error if textbox have Multiple values [SOLVED]

i'm totally new with VBA and need your help, the problem is i want to select random cells in a given row, as you can see in picture below, the userform have ComboBox X = represent row, TextBox Y=Represent column and CommanButton "Input", i'm stuck with the error when i try to input multiple...

www.excelforum.com

A message to forum cross posters

frankly i didnt know such things like that in web forum, and thanks for the information

 

[petroes]

Cross posted

Writing into random cell base on textbox values, Error if textbox have Multiple values [SOLVED]

i'm totally new with VBA and need your help, the problem is i want to select random cells in a given row, as you can see in picture below, the userform have ComboBox X = represent row, TextBox Y=Represent column and CommanButton "Input", i'm stuck with the error when i try to input multiple...

www.excelforum.com

A message to forum cross posters

i really didn't know about this rule, so i want ti delete this thread on here