Hello,
Many thanks in advance if someone could help me resolve this issue!
The Userform data are not being added to the right column, something is not right...
Column C, G, I, M, N, W, X, should be blank because of the formulas in these columns.
Big thanks for your help!
.
You are using an ARRAY to enter your data in the sheet columns. The data is populating one column next to the other, without indication (to Excel) where to place the data.
Edit your macro so the data is being entered from the form in this manner (no array):
(This is one way of reaching your goal)
Please Login or Register to view this content.
Thank you so much Logit!
Was capable to update the "Add" part, but still having issue with the "Update" part, Could you please help me again?
PS.
Do you have by any chance a file with Userform options available?
I have a Check Box button in this file and I am still trying to understand how it works.
Thanks again!
Could just add the formula for those cells to your array. Something like below
Please Login or Register to view this content.
Thanks,
Mike
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved.
.
mike:
I looked around for a solution using the ARRAY method and was not successful.
Your suggestion as presented, would that encompass ALL the columns he is using or does the line of code need to be expanded to include all the textboxes by name ?
ex: Rng.Rows(Rng.Rows.Count).Value = Array(TextBox0, txtName, "=Month(RC[-1])", TextBox2, TextBox3, TextBox4, TextBox5, TextBox6, TextBox7, TextBox8, TextBox9, TextBox10, TextBox11, TextBox12, TextBox13, ComboBox1, ComboBox2, ComboBox3)
I'm still learning !
Hey Logit something like below. This is not correct but will give a general idea.
Column C, G, I, M, N, W, X, should be blank because of the formulas in these columns.Edit: Also don't see a Formula in Columns that OP is saying there is a formula.Please Login or Register to view this content.
Ex: Columns G and I doesn't have a formula but Column H does. So I'm a little confused
Last edited by mike7952; 11-24-2017 at 06:27 PM.
.
Tks .........................
Thanks you so much! Now, Add & Update are working with "Array", BIG Thanks!!
Just a quick question before "SOLVED", do you have by any change the VBA code to copy/paste the table format to the new added row?
Thanks again!
Is the new data going to be added to the table or in the rows below like your example workbook?Originally Posted by scoclu
Would be added in the table, thanks!
Could use a sub like this
and pass your array like belowPlease Login or Register to view this content.
Please Login or Register to view this content.
Perfect! Thanks for your help, really appreciated Mike!
Your Welcome
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks