data entry form

ddoyle67

New Member
Joined
Apr 4, 2013
Messages
36
I have looked in google and not found the answer to this question. 2 actually First is it possible to edit which fields appear in the data entry stock form. I do not want all of the columns to show up in it. I have formulas in some of them that will calculate based upon the what data is entered. ex: show columns A,B,C,D,E, G,I. instead of A through M. Those columns that have formulas and a couple that get the data I want to be hidden. but when I hide them or change the column width to 0 they disappear from the data entry form. I want them in the data entry form but don't want to see the columns. Is there any way to do both of these things. I want to eventually create a form on a sheet not the stock pop up but do not know VBA well enough to write the code.
 

Logit

Well-known Member
Joined
Aug 31, 2016
Messages
2,907
.
That is what happens when you hide a column or a row ... it disappears from view.

You could create a macro that would make the columns/rows visible while you are working on the data, then hide the columns/rows again after you are finished.
There is plenty of sample code on this Forum and others .. as well as the internet for hiding columns/rows.
 

Forum statistics

Threads
1,078,308
Messages
5,339,400
Members
399,302
Latest member
Swiftymj

Some videos you may like

This Week's Hot Topics

Top