Create Vba Feedback Form
how to Create a Vba Feedback Form?
View Complete Thread with Replies
Sponsored Links:
Related Forum Messages:
Create Form To Output Data And Erase Form Once Data In Ouput
I am trying to create a form to use as a golf tracker. I basically have created a scorecard where I input the date, score, fairways in regulation, greens in regulation and putts. I want to be able to put that information just like if it was a scorecard and then have a button that says submit. Then that information is output into individual sheets (i.e. one for scores, one for fairways, one for greens and one for putts).
View Replies!
View Related
Create A Form That Logs Data
I would like to make a form where a user can fill in information in an easy to ready format, then click a submit button, and have the data moved to another sheet or file from where the data can be merged into another document. Each time the user fills out the information and clicks submit, a new line of the data is created in the destination. Here's a picture to show what I'd like to do: http://i305.photobucket.com/albums/n...r5/example.gif
View Replies!
View Related
Create New Page In Multipage Form
I have a UserForm with a MultiPage form on it. Page1 is a totals page with 3 TextBoxes. Page 2 and counting are item pages. Each page also has 3 TextBoxes (nutrients for that item). Purpose is to add all of the values in the first TextBox on pages 2 + and place the total into the first TextBox on page 1. Repeat this for the other two TextBoxes. The problem is that I have no way of knowing how many pages I will need! Is there a way to add a new page to the MultiPage and copy all of the formatting and controls from the formerly last page on to it? I would like to do this with an "Add" button.
View Replies!
View Related
How To Create A Check List Form
I would like to create a form to select some columns from a list of columns. This could make it simpler for an end-user to chose which columns they want to see in my application. (see my previous question: [url] Ideally, I would prefer to do that just like rows can be selected in an Excel list. However, I doubt this could be done. So, to be practical, I would put a button on my sheet. When the user clicks the button, a form would appear and show the current list of columns. The user would mark or unmark to define his view and click ok to get the sheet with only the columns he wants. The number of column in the table can change. When the form loads it must determine what are the columns to include in the list (headers). What I really don't know is which controls I should use on the form? Are there some list control with tick marks available, for example? Or, I might dream of a mark-enables combo box or list box, as can be seen often on the web.
View Replies!
View Related
Create A Form With 5 Headers And Each Header Uses Unique Database
I need to have a end user form that pulls information from a database and simplifies work for our substitue coordinator. Please be advised I have been working on this and can not get the desired results. I need a form that displays the current date and 5 columns of data the Data needs to be in seperate cells for example cell A1 titled TEACHERS and then the sub coordinator could start typing the name of the teacher in a2 and a predefined database of teachers name, class they teach, etc. MATH, ENGLISH and planning period would be pooled and automaticly fill the cell. I also would need a second cell say cell B to be call Substitutes and b2- b100 to pull data from a database of substitute names and display their information.
View Replies!
View Related
Using VBA To Create VBA Code On The Fly
I have a vba module that reads a value from a txt file and saves that value in a variable called "iniInfo". I want to permanently assign that value programatically by using VBA code to create a Public variable e.g. "PUBLIC CONST conFIg = iniInfo" in my modGlobalVar Module. (Of course, this would only create the code if the "conFig" variable doesn't already exist.)
View Replies!
View Related
Form Communicate With VBA
I have three subs that are exactly the same except they call three other different functions from an Access database and I'm trying to create a form that has three radio buttons so that the user can select which of the three functions they want to use. I've created a form (Insert>UserForm) and I call the form in the beginning of my sub UserForm1.show but I don't know how to close the form and have it start running the sub again. Do I need to create a 'Close' button that will refer back to the sub or something?
View Replies!
View Related
Vba Form Crashes Intermittent
I have written a fairly large spread sheet, and I have consistently had excel crashes when the first form initialises at startup. However if I resave the workbook over itself or sometimes as another name it will then work. Once it works - it will always work while I dont restart my computer. The next day the same workbook will crash on form startup. Once this happens t always crashes on startup. If it works OK first up it always works. However if I edit it the process may happen all over again. I am 100% their is no error in the code as in certain stages it has worked for months. It seams like some bug in excel? Has anyone ever had this issue?
View Replies!
View Related
Autorun Vba Form On 2007
I have created a VBA form in excel 2007. Currently I can only open it by using the ALT+F11 key press to switch to the VB window and then run the form. I want the form to run as soon as the excel file is opened. I was able to do this in the past with excel 2000, but I cannot do it in the 2007 version.
View Replies!
View Related
VBA ListBox Form Unloading
I'm writing a audit trail that when the user changes a cell in a specified column the reason for the change gets recorded in a different sheet. If however the list box is cancelled then the cell should not change. The code should do the following:call listbox when cell value change user selects one or more reasons from list if nothing selected then prompt for selection record username, date, cell value and reasons if click cancel then undo change, i.e. don't allow user to change the cell without selecting a reason Steps 1-4 works well Step5: cancel undo the cell change, but doesn't unlaod the form and hence the load-unload goes into a loop. Private Sub Worksheet_Change(ByVal Target As Range) If Target.Column = 15 Then Call Launch(Target) End If End Sub Module Global reasons As String Sub Launch(tRange As Range) Dim prodId As String...............
View Replies!
View Related
Fill An Online Form In From VBA
I've got access to a website that you input a bank account sorting code, and it tells you which bank it relates to. I've got a file with several thousand a month to check. It need a login and password but I've got them, so could have the screen open. On the website, I enter the sortcode into a field, and it returns the bank who owns that sort code onto the screen as selectable text. Is it possible, using VBA, to fill in the input field, press the search button, and snag the value returned in the text box?
View Replies!
View Related
VBA: Sort And Report To A Form
From the sample file, I am using the data on (start) worksheet. (Sort and report sheet). I'm after a reporting routine that I want to run on the launch of a Userform. What it would do in an ideal world is when I click the "launch report" (command) button in Excel, it would look at a sheet (start), and extract the top 5 values from the sheet, both for the overall list, and the top 5 values per unique name, then returns that data to the Userform for viewing only.
View Replies!
View Related
Form Control Listbox VBA
i have a form control listbox (list box 5), it is multi select, i need to create a for next statement that loops through the list in and tells me which "row numbers" as it were are selected. i.e if the 1st and 3rd ones are blue, it returns 1,3 in a cell? (lets say cell A1).
View Replies!
View Related
Delete Code For Vba Form
Find, View, And Replace Values With A Form Mr.Bill provied a help by submmiting an example... i liked the example and i did try it. the example is NOT complete.. i would like to do 1. delete option [ i did it but when i did it delete the whole rows then i retype the columns again ] 2. to filter the data which are approved in another sheet in case you did get my questions pleasae do download the [Tracker-Suggestion. zip ] in this link Find, View, And Replace Values With A Form
View Replies!
View Related
Search For Hidden User Form With VBA
I have a userform which puts information in a main sheet, however there are 6 other sheets which the user may need to use to give detail on aspects of their main. so on my main form I have 6 buttons which call other user forms and hide the one for the main. However there are 3 mains as their are three different groups. So when done with the secondary user form and the user chooses to close the form I would like it to check to see if for instance frmInput1, frmInput2, or frmInput3 are open and just hidden. If it finds one that was open and hidden bring it back to view.
View Replies!
View Related
VBA Code For Fliping Images In A User Form
find a VBA Code for fliping images in a User Form. What I want is that, I have a user form in which I have a command button "Next" & "Previous". I want whenever I click "Next" button my image control should show the next image & whenever I click "Previous" button my image control should show the previous image. I tried many logics but failed. Might be you guys will crack this hard nut.
View Replies!
View Related
VBA Macro To Return Maximum Value In Text Form..
I am a novice to VBA in excel, i have a table of more then 5000 rows. I would like to find a maximum value from each row and return the column title as "GL_Weld" or "Bend" or "Header" into another worksheet cell. i.e First Row max value = 0.011510 should return "Bend" into another worksheet GL_WeldBendHeader 0.0001700.0115100.000500 0.0000000.0007800.000000 0.0002400.0110700.000480 0.0000000.0006600.000000 0.0000000.0037700.000000 0.0000000.0000100.000000 0.0002800.0108700.000480 0.0000000.0007100.000000 0.0002000.0112900.000490 0.0000000.0008400.000000 000.00002 00.000310.00001 000.00004 00.00030.00002 000.00001 00.000270.00003 000.00002 00.000260.00004
View Replies!
View Related
VBA Data Entry Form - Populating Separate Book
I have built a data entry form (Input tab) and have code populating a table (Table tab). Currently both are in the same book, but I would like to house them in separately. What is the proper VBA syntax for this? Will both books need to be open in order to populate the table? The 'real' data is hosted on sharepoint and is getting darn big. The result is problems opening the doc and looong save times. My thought was to have the secretaries doing data entry open a single sheet (Input Form) which will then populate the data in another sheet. I'm dreaming, aren't I... I know Access would solve everything, but for cost reasons I am stuck with Excel.
View Replies!
View Related
Conditional Formatting And A VBA Code To Make Sure The Cond. Form Is NOT Active
I am trying to add something to a spreadsheet. I want to do some Conditional Formatting but I am not certain on what the formula would be to accomplish it. I am putting the Cond Format in cell E5 and I need a formula to say: IF F5 AND G5 are BLANK then do the format I set up which is simply to fill the cell with RED. (.ColorIndex = 3) The next portion of my problem is I need to revise my VBA Coding to check and make sure that there is not any cells in Column E that have the Formatting Active. This is the portion of code I need to alter. I have changed the wording of the message but am not sure on how to change the IF statement: 'Checks to see make sure there are no Actions or Resolutions WITHOUT a Topic If Sheets("Meeting Minutes").Range("C1").Value = "" Then 'NEEDS TO CHANGE MsgBox "Oops! You forgot to enter a Topic for Discussion in a cell(s). You MUST have a Topic in order for your Meeting Minutes to transfer to the Master sheet." & vbCr & vbCr & "Please click OK to return to the Minutes sheet so that you may fill in the Topic(s).", vbOKOnly, "CAUTION! PLEASE Note!" Range("D5").Select Application.ScreenUpdating = True Application.StatusBar = "" Exit Sub End If
View Replies!
View Related
Create Graph Using VBA
I want to create excel graph using VBA and found difficulties on chart name set to default. the script is like this : ActiveSheet.ChartObjects("Chart 31").Activate Can I set my own name of the chart instead of "Chart 31" (excel default) ?
View Replies!
View Related
VBA To Create New Sheet ...
I would like to be able to have a macro, linked to a button, so that when you press that button it creates a new named sheet based on data in a particular cell. I.e. There is a table with the following data: Apples (A1) Oranges (A2) Pears (A3) There are also the sheets Apples, Oranges & Pears. You enter 'Grape' in cell A4, then when you press the button it creates a new sheet named Grape. Also when a new sheet is created, the 'input cell', in this case A4, is moved down one so that when the next sheet is needed to be added, it doesn't just add the same sheet (i.e. in the example above, we don't end up with a new sheet named 'Grape' each time we click the button).
View Replies!
View Related
Create Tag In VBA?
I found this really cool code that creates a tag cloud in Excel using VBA. It's far too complex for my understanding but I was hoping I could get some of the experts opinions on here about modification possibilities. I have attached the macro-enabled 2007 workbook. What I am trying to do is search through a list of keywords and determine each keyword's density within a list. The list for example could look like this: slow windows xp windows xp running slow windows xp computer [slow windows xp] [windows xp running slow] [windows xp computer] [computer running slow windows xp] "computer running slow windows xp" "slow windows xp" "windows xp running slow" "windows xp computer" You'll notice the characters " [ ] of which I would like to ignore when the cloud builds. The cloud would list the most dense keywords first, and gradually decrease to the least dense keywords. The macro code is inside the workbook but I'll list it here to:
View Replies!
View Related
Create VBA InputBox
I am trying to create an inputbox using code from this site: Sub NumericDataType() Dim lNum As Long On Error Resume Next Application.DisplayAlerts = False lNum = Application.InputBox _ (Prompt:="Please enter you age.", _ Title:="HOW OLD ARE YOU", Type:=1) On Error Goto 0 Application.DisplayAlerts = True If lNum = 0 Then Exit Sub Else MsgBox "You are " & lNum & " years old." End If End Sub I get an error on the first line that says, "Compile error: argument not optional".
View Replies!
View Related
Create Comparison Code In VBA
I have to do monthly comparisons of two excel worksheets, one being a vessel timesheet and the other being an excel download from manpower software that we use. The comparison that is being made are days of the month, whilst the unique identifier between the two sheets (To make it easier to understand I will call them sheet1 and sheet2) is an employee ID. Both sheets, alongside the name and employee ID, list all the days of the month that employees have worked. If they have worked, there is a "1" under that day, if they have not the cell is blank. What I currently do manually is: 1: Search for the employee ID (and/or name) in sheet1 and compare the days with the employee ID in sheet2. 2: Highlight the differences 3: Move onto the next employee ID All differences are highlighted in sheet2. Differences highlighted are in the days only, where if any days are missing/extra in either sheet, then the particular cell(s) are highlighted in yellow. If an employee is missing from sheet1 but is in sheet2, then all the days are highlighted (in sheet2). If an employee is missing from sheet2 but is in sheet1, then that particular employee is copied to the bottom of sheet2 (after last row). As this is horribly complicated to explain, I can attach an example if this is sounding rather inexplicable? Is it possible to attach a xls to a thread?
View Replies!
View Related
Create A New Workbook By Vba Of Excel
I want to the following steps to be done by vba of excel. 1. copy ranges of cells in the active worksheet (sheet3) 2. add a new workbook and paste the copied ranges to sheet1 3. save the new workbook with the new file name (e.g. date) 4. close the new workbook and clear the contents the copied ranges of cells in old workbook. following code and make it more simpler? Worksheets("Sheet3").Activate If Range("l1").Value <> "" Then Range("l1").Value = CDate(Date) End If asdate = Range("l1").Value 'date entered by user resp4 = MsgBox(" Case particulars of " & asdate & " will be backed up and deleted from this sheet! Proceed? (Y/N)", vbYesNo, "Deletion of Data") If resp4 = 7 Then Exit Sub
View Replies!
View Related
Vba To Create A New File From Spreadsheet
I have the following spreadsheet: A-------------B File No.-----PRODUCT TYPE 123456-----NDT 123456-----NDT 123456-----NDT 123456--------- 123456--------- 789110--------- 789110--------- 789110--------- What I need is if there is an NDT in Column B and 123456 in Column A then I need to eliminate all rows which contain 123456. End result A 789110 789110 789110
View Replies!
View Related
Create Outlook Appointment From VBA
I am probably overengineering my macro, but I would like to setup an outlook appointment in two peoples calendars from my userform. The macro has access to the email addresses of the selected persons, I just want to send date/time and subject.
View Replies!
View Related
VBA To Create A New Folder From A Textbox Value
I don't know if anyone has tried this but it possible using vba to create a new folder in a directory from the text of a textbox? I have made a userform that I use to collect a persons first name & surname. I then created a folder in a directory manually (e.g Z:spnzphotos) I then scan their photo and place it into the folder. Is it at all possible to have a piece of code that once I press a command button is creates folder ready for me to add the photo to?
View Replies!
View Related
Vba To Create Separate Reports From Master
I have the following spreadsheet Columns on master sorted by Column J: A--------------E-------------J SUPPLIER----CARRIER------LOC CODE BELGIUM-----HAM-----------BP HYDRO-------MSC-----------BP DAINIPPON---NNR-----------BP BELGIUM------YM-----------BR BELGIUM------YM-----------BR HYDRO-------MSC----------CA BELGIUM-----HAM-----------CA HYDRO-------MSC-----------CA HYDRO-------MSC-----------DE DAINIPPON---NNR-----------DE BELGIUM------YM-----------DE BELGIUM------YM-----------DE What I need too do based on the Codes in Column J is create a separate workbook for each different code.
View Replies!
View Related
VBA Macro To Create New Worksheet, Charts, Etc.
I need a macro to create the following worksheets and charts from an Excel data set: Three (3) worksheets (already created manually in attached Excel file): 1. Chart Data. (a) Column A in Chart Data is always numbered 1 - 600 (50 years x 12 mos/yr). (b) Column I and column Y data sets (from Prod_Month) created in Chart Data. Each data set can be identified and collated with column F in Prod_Month (API) which is unique for each dataset. 2. Rate vs. Month - plot of Daily Gas (col. Y in Prod_Month) vs. Months (col. A in Chart Data). 3. Rate vs. Time - plot of Daily Gas (col. Y in Prod_Month) vs. Calender Time (col. B et. al. in Chart Data) At a minimum, could someone help me create the Chart Data worksheet from the data in PROD_MONTH? Charting all the columns takes time from Chart Data but any data manipulation macro(s) help.
View Replies!
View Related
|
TRACKER
