text boxes

Hi all, I have very little coding expertise and have searched the web and the forum, but couldn't quite find the solution. I am trying to show/hide hundreds of text boxes based on their values. Use case: I have an image of a map (jpg), which includes 222 locations. Each of these locations has...

Hi, I have created an income statement form in access that has a Beginning Date, End Date text boxes followed by Income and Expense text boxes and lastly and Net Income text box. I have tables set up for income and expenses. What I want is to enter a beginning and end date on the form and...

Hello all! I'm hoping for some help in altering the below code to insert a text box below the shape as it is inserted. Realize a sample workbook is probably more helpful but I'm not sure how/if I can attach one. Thoughts on a way ahead would be appreciated! <code style="margin: 0px...

I am writing a macro that copy and pastes the information from sheet 1 to sheet 2 of the same workbook. I can get it all to work except for the text box, which has enough text that it overflows from one cell to another when copy and pasted. The text box was put in using insert-text box. When...

I use an Excel format for my field staff to enter information (assessments, investigations, etc.) Through a complex combination of macros, formulas, and vlookups, I have the form set up to populate data based on a location and/or employee ID number This seems to be working well for everyone...

Hi All, I have hit a bit of an issue when creating a system that keeps track of issues coming into an inbox (it’s kind of like a database of issues). Because the cells will contain so much data I have had to insert textboxes that have scrollbars to see all the data (they are linked to the cell...

Hello, I am new to using macros and VB but am very familiar with other aspects of Excel. What I am working on is a spread sheet for writers for my newspaper. I have a spread sheet created Pictured here. What i would like to do is have it to where the person who makes pays our writers can...

Good morning. I have some reports with charts in them that I need to place empty action item, owners and due date labels or boxes on that can be printed out. I have tried labels but they disappear when there is no data. I tried rectangles also and text boxes but neither will work. How do I place...

Hello, I have a code that mostly works. The only problem i am having is when the text boxes populate, they always populate the last item in my list, and not what i am clicking on. Any help would be greatly appreciated. Private Sub ComboBox2_Click() Dim LR As Long Dim fRng As Range...