LinkBack URL
About LinkBacks
Hello!
I am trying to put this formulas into Userform VBA:
Even if I put additional " " it doesn't work properly.
Please Login or Register to view this content.
Could someone please help me?
Many thanks!
Hello!
I am trying to put this formulas into Userform VBA:
Even if I put additional " " it doesn't work properly.Please Login or Register to view this content.
Could someone please help me?
Many thanks!
Last edited by scoclu; 11-29-2017 at 10:47 PM.
Not in to cell?
try something like
Please Login or Register to view this content.
Thanks Jindon, sorry let me be more specific,
In fact I have to add this formula
Private Sub cmbAddRecord_Click()Please Login or Register to view this content.
Dim arrNewData
Many thanks!Please Login or Register to view this content.
Last edited by scoclu; 11-29-2017 at 10:47 PM.
1)
Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.
Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.
Click on Edit to open your thread, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here
2)
Is it just
?Please Login or Register to view this content.
Sorry stll not working, I am having an error with ' before MASTER...
How are you entering to the cell?
is it just Formula? or FormulaR1C1?
It will be like this :
Please Login or Register to view this content.
But it's not working because of the ' in the Index formula
Thanks a lot
Last edited by scoclu; 11-29-2017 at 11:30 PM.
If I just enter
It works, assuming Soumission is a named range.Please Login or Register to view this content.
Sorry still not working because of the ' of the 'MASTER SOUMISSION'! part...
You are right Soumission is a named range of the Index formula,
Thanks!
Isn't it a sheet name?
If you upload a workbook, it will help to know the situation...
Hello Jindon, sorry for the delay,
Finally a genius named Mike, found the formulas:
For those trying to find the solution, remember to respect the "Please Login or Register to view this content.
Thanks
That's what I originally posted.
You have extra ) in your Array
Please Login or Register to view this content.
¨Perfect! thanks Jindon for your help,
You are welcome and thanks for the rep.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks