Contextures refers to a macros to add imput areas, Unable to find this macro to add imput

O.M.G. I would be doing a mis-service if at this stage I did not introduce the use of 'UserForms' for this sort of application.
The whole process is dealt with within the UserForm environment (no on sheet formula required - all code within one 'envelope').
Have a play with the attached file, to 'Add' new file first press 'Clear' enter your data then press 'Add', the rest should be intuitive.
Any queries post back on this site.
torachan

Thank you Torachan, but what you sent wont work, I have to be able to customize something like 600 data entry points per item name, and it has to appear on one excel sheet, not on a separate form and can only have limited formulas for a database that will have close to 65,000 different items, with 600+ data points per item, this is why I chose to use the contexture form rather than a simple user form. the problem is the bloody VBA code... I am not seeing where to modify it to add the additional input areas they are refering to.

@born2dive00, why not put your actual case to the forum for a solution.
Drawing on years of experience I would speculate there are far more efficient ways of solving your problem than the course you are on at the moment.
Excel has moved on greatly in the 18 years since the app you are trying to adapt was written (10/08/2003) ???
Merely trying to save your sanity.
torachan.

Hey Torachan, I'm using 2007 as it is the most common excel program used by international users especially in third world countries. but I the advice about updating.

As far as the workbook that I am working on it was built to my understanding in 2018 so only a couple years old.

The problem is once finished I need for anyone to be able to download the final spreadsheet. I can nor do i want to use specialty programs, hence with excel it can reach the most people who may not have the finances or technical capacities to purchase other programs.

What is nice about this sheet is it is simple VBA (IF you know how it works, and how to modify the code which I dont)

@ Torachen, I have modified the original book to include 3 additional sample fields, but on the contexture website they say that I must modify the VBA, they state as follows.

"If you need more input areas, follow the steps below, and use the setup and naming structure for the existing input areas as a guide. In this example, a third input area is being added:

Input sheet: Create new input cells, and name that range as InputC
PartsData sheet: Add columns for new fields
Input Links sheet, add cells in row 4, copy formulas across in rows 5, 6, 9
Adjust the InputCopy named range to include the new formula cells
SelRecordLinks sheet, set up formulas for new input range (use same cells as on Input sheet)
Name the value cells as SelValC
In the code (Alt+F11), add lines for new input area (InputC), wherever there is code for InputA and InputB. To find them, press Ctrl+F, to open the Find window, Find: InputA, Search: Current Project. Then, copy the line for InputB, paste, and change to InputC. "

Attachment 739352

Now I can not find where it says InputA, InputB, InputC, the only thing I have found even close to to the code in the photo with SpecialCells is in the UpdateLogWorksheet, UpdateLogRecord, and in the DeleteLogRecord where it says

Please Login or Register  to view this content.

Do I have to change the code here, and if so what do I have to change it to, to add the 3 additional input fields in the attached workbook?

@borntodive00, I will step back at this stage, hopefully others may step forward to help.
I fail to see the point in coding with out of date techniques that will inherently cause problems with the data sizes you are indicating.
What lead you to believe the code was written in 2018, when the 'properties' indicate otherwise.
Best of luck.
torachan.

Attachment 739390

Hello ToraChan

When you download the Zip it says the excel sheet was last modified Feb 4, 2021 and the video in youtube how to add additional fields was posted on Aug 17, 2019, and somewhere on the contexture website, I have seen the date for this book being of 2018...

So I dont know....

Right now my hand entered database is 18mb with 27k rows with about 200 data points per row, and it runs fine on my desktop, takes about 2-5 seconds to find the row and data in the table, but I need a faster way to enter the additional data as doing it manually really sucks, and i have found more than a few errors in the data i have entered mainly duplicates. Hence why I am trying to get this workbook to work and display.

Any help you can offer would be great.

In post #4, I have suggested that you put your actual case to the forum for a solution.
I have looked through all the posts and related 'contextures' files and now your new adaption of the 'database' format it reinforces my opinion that this would lead to a total waste of time for both of us.
Sorry, but someone else may take this on, I neither have the time nor will to produce a 'bodge job'.
torachan.

Hey Torachan, This thread and the problem was originally posted in the general forum, but it was moved her because of the VBA, unless I am missing your meaning by actual case I have already stated the problem here.

Right now my hand entered database is 18mb with 27k rows with about 200 data points per row, and it runs fine on my desktop, takes about 2-5 seconds to find the row and data in the table, but I need a faster way to enter the additional data

I would presume the case you are trying to address is the one above not how to expand the 'contextures' database.
Therefore why not deal with the actual not the hypothetical.

Hey ToraChan, I took a look at the user form file you posted earlier. I may be able to make this work IF we can make 3 critical changes,
1. when the user form is open, i can switch the views to the other sheets, so I can see on one monitor I can see the user sheet and on the other monitor I can see and have access to data on the other sheets. can this be done?
2. i see that we can adjust the user sheet height, BUT the user sheet becomes larger than what the monitor can accommodate, is there any way when the user sheet is open that we can add a scroll slide bar on the right hand side that we can use to see all the entry fields that are hidden below the bottom edge of the monitor.
3. is there a way we can resize the user sheet to fit the monitor screen much like we have the minimize and maximize on the upper right side of the programs we use.

4. last but not least, if we can extend the parts data out to say 400 columns....

if we can make these 4 changes, then I think I can use this user sheet setup...

please see attached file to see what I am referring to.

Hey Torachen, I fixed 2 of the 4 issues I was trying to make work on your sheet,

I found out how to install the vertical and horizontal scroll bars so that is fixed,
I also figured out how to get the user sheet to work independently from the other sheets, meaning I now can keep the user sheet open on one screen, while operating the other tabs and making changes on the sheets.

I kind of fixed the re sizing issue, I got the usersheet to resize to the same size of the monitor that it was initially opened in, but, when I move it to my second monitor, it wont resize to the new monitor size, how do I get this to work so it automatically resizes when it is dragged to a new monitor.

I still have not figured out how to add the additional cells to increase the table to about 400 columns, could you help me with this.

If I can get the last 2 things to work, then I can use this for my database.

please let me know and thank you

Sorry, we are totally on different wavelengths, you do not put anything into the sheets manually.
Give me a clue why you need 400 columns and I will give you a dozen reasons why you do not.
torachan.

Hey ToraChen, Lets abandon this thread, as we are now on a completely different issues between the different books and it has gotten confusing for both of us. and it appears the contexture book wont work.

I started a new thread dealing specifically with your book you sent me. it is here, https://www.excelforum.com/excel-gen...-workbook.html

I will go there and explain what I am trying to do that specifically addresses your book and the mods there. This way if some one can offer help on this thread on the contexture book it wont confuse anyone.

The new question and issues pertaining to your book are now posted at the other thread. I want to keep this one open solely for the Contextures book

Cheers and thank you for your help