Posts by aadarsh

Re: Run Function from other File in Module

Hi use file2!CheckData(Value)

That shd do the trick

Aadarsh

Hi

I have a list of option buttons say OptionButton1 to OptionButton8, one of which the user can select..

Since the form became too long, I decided to use multipage, with few buttons on first page and rest on second.

Now when I select a button on page1, I can also select one on page2...whereas I want the button selection to be unique accross both the pages..

Is thr any way of doing this

aadarsh

Hi

I have this userform, which is pretty long. It fits in 1024x768 but dosent in 800x600.

Is there anyway in which i Can make say a scrollbar appear if the userform does not fit on the screen, so ppl with lower resolution, can just scroll down and hence see the whole form

Aadarsh

Re: Display entered data from one worksheet onto another leaving out the blanks ones

Hi

Welcome to OZgrid

Which sheet data do you want to use and in which sheet do you want the output.
Also which is the column you are basing your check on...Its simple VBA, just answer my above queries will send you the code

Aadarsh

Re: Problems with Formating of Imported Data

Hi

Try changing Formatting to text or number.
If it dosent help, attach a sample, will checck it out

Aadarsh

Re: Data Selection based on date

Why dont you use date-1 to get the reference document..
If it is not first day of month,yesterday is still same month...if it is first day, then it will use previous month

Aadarsh

Re: Macro runs on SaveAs

Hi

Could you attach a copy of the workbook...
Also does the workbook have a before save event??

Aadarsh

Re: Select column based on macro button location

Quote from rpaulson

Thanks for the relpy, but I get a runtime error 424 Object required on the
cs = Line

Sub Mainscoresheet()
' Mainlineup Macro
Dim k As Integer, i As Integer, cs As Integer, ws As Worksheet, sh As Worksheet, rs As Integer, hr As Integer, hc As Integer
cs = CommandButton1.TopLeftCell.Column 'Column to start
.......

Display More

Are you sure the button you are using is called commandbutton1??

Aadarsh

Re: Select column based on macro button location

Hi Ross

You can use the following code to get the topleft cell's row

cs = CommandButton1.TopLeftCell.Column

Re: hiding a worksheet

Hi

I didnt get your question...hide a worksheet in a worksheet

You can hide worksheets within a workbook

Aadarsh

Re: populate combo box with Access data

Hi...

First you have to select the records using a recordset, then u can populate...

Aadarsh

Re: [Solved]-Source Data in chart

Hi

Used dynamic named ranges to solve my problem

Thanx

Aadarsh

Hi

I can set the source data range (range from which chart is drawn) using the SetSourceData function.

But i am not able to set the series name and the X-Axis labels using code. Can anyone help me out

Aadarsh

Hi

I have a database with many tables linked by ODBC to Sybase.

On clicking on the linked table, i get a prompt simlar to the picture attached.

Now if i need to connect to this database and run queries on this table, how do i open it directly from code without it prompting for pwored(can somehow fill through VBA)

Aadarsh

Re: Populate column with files from selected folder

Hi

You cannot select a folder with getopenfilename()

Try the attached workbook..
Run the code from module1

You can modify the "*.*" in module1 to any other filetype, to output files of selected type

Aadarsh

Re: Assing macros to Options Buttons?

Hi

Do you want to run the macro each time the optionbutton changes or if its clicked

You can use one of the folowing events

OptionButton1_Change()
OptionButton1_Click()

Aadarsh

End Sub

Re: 66 option buttonsto be disabled

Hi

Use the following code

For i = 1 to 22
If wsheet.OLEObjects("OptionButton" & CStr(i)).Object.Value)=False and wsheet.OLEObjects("OptionButton" & CStr(i+1)).Object.Value)=False and wsheet.OLEObjects("OptionButton" & CStr(i+2)).Object.Value)=False Then
Msgbox "answer all Questions
End IF
Next i

Re: 66 option buttonsto be disabled

Alternantively

You can also use

For i=1 to 66
wsheet.OLEObjects("OptionButton" & CStr(i)).Object.Value)=False
Next i

Re: text in a popup box when going over cell (not comments)

Hi

Worked perfectly thanx

Done with this project now

Aadarsh

Re: text in a popup box when going over cell (not comments)

hi

will try it out when i get back to office

Aadarsh