I've got a formbox that has scrollbars and when the userform starts up the vertical scrollbar is centred, meaning people can't see the top of my form. How do get the scrollbar to be at the top when my form loads?
View 2 RepliesI have one userform that loads combobox values upon userform Initialize. Though through a second userform changes can be made to anotherworkbook this workbook is saves any changes. when i close the second userform i need to rerun the 1st userform Initialize event to update the combobox's incase changes have been made.
View 5 Replies View RelatedI have a combobox with populated values from a named range. I need the first value to be always selected when the form is opened - is there a way to do this
View 7 Replies View RelatedWhen I click the command button that is supposed to close the userfrom, it closes it but it re-appears again. It closes completely when I click the "Cancel" command button again. It seems to reload the userform when the command button is initially clicked.
Private Sub CommandButton1_Click()
Unload UserForm2
End Sub
I have a large userform (Main) that the users enter data into. At the end of the data entry the users click OK and the data is transferred to a spreadsheet. I then ask the users if they want to add another record. If they click "Yes" all is OK. If they click "No" the userform should close and another "switchboard" type userform should open.
My problem is that try as I might I cannot get the (Main) userform to close. It only does so after the switchboard closes.
If I don't load the switchboard, main closes without issue.
I have left out the bulk of the data transferred to the "data" sheet in the code below.
Private Sub Main_OK_Button_Click()
Application.ScreenUpdating = False
Sheets("Data").Visible = True
Sheets("Data"). Range("F2").Value = Surname.Text
Dim result As VbMsgBoxResult
result = MsgBox("Do you wish to enter another record?", vbYesNo + vbInformation, "Continue...")
If result = vbNo Then
Main.URN.SetFocus
Unload Me
Else
I am trying to get a scrollbar on a MultiPage UserForm to provide instant results on the active spreadsheet. The spreadsheet is full of charts, and as you move the scrollbar, the charts change. Trouble is, the code I have is VERY slow. Moving the scollbar turns the cursor into an hourglass and that little scrollbar graphic lags about a centimeter behind. Is there faster code out there?
Here is what I have:
NOTE I use both the change event and the Scroll event because using only one gives me only half the functionality of the scrollbar...that is, without both, either the arrows on the scrollbar work or only the slider works.
I currently have an ActiveX scrollbar on a spreadsheet that's tied into a chart. Move the slider on the scrollbar, and the chart instantly updates.
I then put a scrollbar on a muli-page UserForm and the chart will only update after the form is closed. Is there a way I can get the chart to update instantly just like with the ActiveX control?
I'm missing something in my UserForm initialization code. If I fill the form out once and click 'OK' (run the code to put the form data into a sheet), when I go back into the form all the old info is still there. If I then click 'Cancel' (Unload Me) and reopen the form, the old data is cleared out. What am I missing to make it clear it out the first time?
View 2 Replies View RelatedI had made some code changes that didn't end up working as I wanted and this called for PERSONAL to be called and acted on when excel was activated. Now I have deleted the code but still on opening excel is persists in loading PERSONAL. urk. How can I go back to loading Book1 on open?
i have a drop down menu listing all the months (as displayed) and once I pick a month, anyone that has an anniversary OR birthday during that month loads into the columns to the right.
I have tried various ways of doing it but for some reason It just wont pull the info right. The previous posts have shown me scripts for Vlookups and a variety of other things. But the end result was not exact.
I have the following code which loads the data into the pivot table.
View 2 Replies View RelatedI've recently purchased an add-in for Excel 2010 called Image Assistant. It allows you to insert loads of images at once and automatically puts them in the cells for you, which is what I need to create quotes for my business. It was painstaking to go through resizing each picture individually so I thought I'd give this a go...
The demo of the program worked fine, except it restricted you to one picture at a time and I have thousands to go through. It resized the picture great and put it in the cell as I expected.
So I purchased the full product. There didn't seem to be an option to just put a license key into the demo version to make it full, and I was sent a link to download the full version, so I did.
When in Excel, I click the icon in the add-ins window and Excel grinds to a halt. It stops responding instantly and then won't do anything until I force close it, at which point it pops up with "Automation Error" and then closes the program.
I've checked DEP settings, trust center settings, add-in settings. I've tried 'repairing' Microsoft Office in case it was an issue with Excel itself but that didn't work. I've uninstalled and reinstalled the add-in several times and it still freezes every time I open it.
Problem signature:
Problem Event Name:AppHangB1
Application Name:EXCEL.EXE
Application Version:14.0.7109.5000
Application Timestamp:522a4031
Hang Signature:31f9
[Code] ............
pop up form within userform to confirm choice. I have a button within a userform that clears the form:
View 5 Replies View RelatedI have a series of Userforms that I would like the user to be forced to enter in some sort of information in one of those userform in the series. I do not want it to be submitted blank. Is there a code or a properties toggle to make this possible.
Code:
Private Sub CommandButton1_Click()
Application.ScreenUpdating = False
Sheets("MDF").Select
Range("RailcarNumber").Value = TextBox1.Value
[Code] .......
I have a userform that will be a 'work order' for repairs. The ladies in the office can fill out all the blanks that will be entered into the spreadsheet. Each time someone is done, it will plug the information on the next available row on the spreadsheet. Easy enough.
What I need is putting a 'work order number' on the form. I have put numbers (101, 102, 103...) in Column A on the spreadsheet. I would like the form to pull the next available number and put it at the top of the Userform. I want this number to be 'locked' in so the ladies can't change it.
My goal - when the ladies are filling out the form, they can see what 'work order number' has been assigned and can give this number to the maintenance.
what is the proper terminology for the Outlook "Thing" that opens up in excel (shown below)? Is it simply a toolbar? Add-in?
Second question, I have a excel file that automatically loads the outlook "Toolbar" each time it is opened.
The file was made in 2010 and password protected and locked, sent to a worker who edited the appropriate fields and saved, and then they sent the file back to me (2003 Format). Now this file automatically loads the outlook toolbar. I am trying to trouble shoot so what would cause this behavior?
I have a userform which allows user to selected a date formt he calendar. In my code I name the value selected myDate. I want to have a line of code at the begginning of my code that checks if myDate = a date already listed in column H on a sheet named "all dor's". if it does match then a msgbox appear saying "date already entered" and the code return to the opened userform.
View 9 Replies View RelatedI have been working on large project using Excel VBA for several days. My code seems to be working correctly, but I have more to do and now, when I drag an object from the toolbox onto a UserForm, the object is not added to the list of objects on the form. If I go back to versions of the project that I was working on several days ago, there is no problem. If I run "Workbook Rebuilder", the objects that I have dragged onto the form are then added to the object list, but I still can't add new objects to forms from within the VBA editor. Is the project corrupted, or is there some other explanation, and are there any fixes? The code runs about 50 pages, and there are over 20 forms, so redoing from scratch is only a last resort option.
View 3 Replies View RelatedI have a userform with numerous text boxes. One textbox is used to input a date with the following code
[Code] .....
When I have completed my userform I want to export this date as a date into range(a2) so I can then use the filter function to filter by month or year. THe problem I am having at the mo is that in the userform it is formatted as dd mm yy, but when I export it from userform it changes to mm,dd,yy. So if I entered 12th January 2014 it changes it to 1st December 2014.
A workaround is to export as text but then I use the filter by month year function so would prefer to avoid this.
Using Excel2010 in Windows7. I have a UserForm
1: TextBox for Input Username (txtUsernameIn)
2: TextBox for Input Password (txtPasswordIn)
3) Submit Button (cmdSubmit1)
I have a Worksheet
ColA: Username
ColB: Password
And this entire Range A:B, I have named "UserRegister"
I have code, attached to the cmdSubmit1 button on my UserForm. The purpose is to allow access to a veryhidden Worksheet "ADMIN".
The code 'works' if I enter in both the correct UserName and Password (ie: the code completes & Admin sheet opens up).
The code 'works' if I enter in the correct UserName and the wrong password (ie: code completes it's run, my msg pops up to say there is wrong input, unloads the form & sheet ADMIN stays veryhidden).
However, if I enter the wrong username (with either right or wrong password) the code breaks and I get a debug error. I know my code is obviously wrong/missing something etc - but I can't work it out! The line of code highlighted on the break, is between the *** below
VB:
Private Sub cmdSubmit1_Click()
Dim Username As String
Username = txtUserNameIn.Text
Dim password As String
password = txtPasswordIn.Text
[Code] ......
can u hide the xl vertical scrollbar or stop it working
View 4 Replies View RelatedI have a table with numeric information with only one column in the table having text information ( which is basically notes from a telephone conversation). My question is how can you add a scroll bar in a cell with text information. I do not want to resize the row height as it makes my table look untidy.
View 1 Replies View RelatedI have Userform with Combobox for listing all days of active worksheet. Worksheet is very long and I would like sheet to scroll left or right, according to what day I pick from Combobox. Days on worksheet are listed in range from E2:AI2.
How could I do that in VBA ?
I have a Combolist box that has 39 entries. The screen isn't big enough for the entire list to be shown when the box is clicked and it truncates the top of the list. How can I add a scrollbar to this?
View 2 Replies View RelatedOn a userform, is there a way in which to set a scrollbar's slider postion to the ListIndex value of the item chosen in a ComboBox?
In other words, if the total ListCount for this choice is is ten, and the item chosen in the Combobox is in the fourth position, can the scrollbar slider automatically be set to the fourth position rather than be all the way to the left or right? I would think that this would make it visually easier for the user to understand in which direction they can scroll the list. Here's what I've got so far:
I want a control to be updated when I scroll a scrollbar. The scrollbar is linked to "B25" and the control, tboYYWW2, is then updated via a HLookup of the "B25" value. By the code below I just get the control updated when the worksheet is activated and not when the "B25" value is updated by the scrollbar. How to make this work ? I also attach the workbook file I'm doing the tests in.
Private Sub Worksheet_Activate()
Dim varYYWW2 As String
Dim varWeekNr2 As Integer
varWeekNr2 = Range("B25")
varYYWW2 = WorksheetFunction.HLookup(varWeekNr2, Worksheets("EDUtest").Range("WeekNrWeek2"), 3)
tboYYWW2 = varYYWW2
End Sub
I have scrollbar control on excel sheet, I want to make maximum value of this control to be linked to a cell on the sheet. So, when the cell value changes, the scrollbar maximum changes automatically with this value.
View 3 Replies View RelatedI have a TextBox in a Worksheet with a ScrollBar defined and its working perfectly! The only problem is that everytime I click outside the TextBox, the ScrollBar goes to the lowest position and I only can see the bottom of the text in the TextBox...
Is there any way of keeping the ScrollBar on its position everytime I click outside the TextBox?
I have been using a scroll bar in my project to select a value from 0 - 3
Is it possible to have a customised slider (whether a form control or something created from scratch) whereby the numbers 0 1 2 3 are displayed in a grey, red, yellow and green box respectively adjacent to eachother and a slider can be moved over the top to select a value?
I've got a large spreadsheet with many cells that need user input. A bunch of calculations are performed on subsequent worksheets, but I want the user to only see the fields they need to enter. I'm trying to write some code that will use a scrollbar (form control, not activex) to only show one group of columns at a time. For example, if ScrollBar1.Value = 1, then show columns "A:D" and hide colums "E:Z". If ScrollBar1.Value = 2, show colums "E:H" but hide columns "A:D" and "I:Z", etc.
Here's the code I'm trying to get going, but I keep getting various errors when I try to execute.
Code:
Private Sub ScrollBar1_Change()
Dim v As Integer
v = ScrollBar1.Value
[Code].....
As it stands now, when I click the scrollbar I get the error: "Compile error. Method or data member not found," and the ".Value" in Line 3 is highlighted.